Em ter., 10 de fev. de 2026 às 07:09, Jim Jones <[email protected]> escreveu:
> Even if parent and children live in the same schema, they become > detached in the new copy -- I'd argue that this one is a bug. > I think the approach will fail at some point if you keep using CREATE TABLE LIKE, because so many things will be incomplete or at least strange, that you'll have to redo many of them. Sequence values will be shared with the old table. Constraints/Indexes names will have to be renamed. Partitioned tables will have to be attached. Foreign Keys are not created either. These are the ones we've found so far, but other inconsistencies will certainly appear. So I don't know if CREATE TABLE LIKE is the best way to do this work. regards Marcos
