Re: Add CREATE SCHEMA ... LIKE support - Mailing list pgsql-hackers

From Jim Jones
Subject Re: Add CREATE SCHEMA ... LIKE support
Date
Msg-id e4c5c6b0-0884-4daf-9840-1db4e25725a1@uni-muenster.de
Whole thread Raw
In response to Re: Add CREATE SCHEMA ... LIKE support  (Marcos Pegoraro <marcos@f10.com.br>)
Responses Re: Add CREATE SCHEMA ... LIKE support
List pgsql-hackers

On 10/02/2026 12:52, Marcos Pegoraro wrote:
> 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.
> Sequencevalues 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.


Quite right. Either we draw a clear line here, or it will be a tough nut
to crack.

Best, Jim



pgsql-hackers by date:

Previous
From: Chengpeng Yan
Date:
Subject: Re: Unfortunate pushing down of expressions below sort
Next
From: Tom Lane
Date:
Subject: Re: Little cleanup: Move ProcStructLock to the ProcGlobal struct