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

From Jim Jones
Subject Re: Add CREATE SCHEMA ... LIKE support
Date
Msg-id 5d8ce6b1-2726-477c-980e-f2113a3e1b45@uni-muenster.de
Whole thread Raw
In response to Re: Add CREATE SCHEMA ... LIKE support  (Matheus Alcantara <matheusssilv97@gmail.com>)
List pgsql-hackers

On 13/02/2026 22:15, Matheus Alcantara wrote:
> Yeah, I agree. I think that we can be less restrictive. The behavior can
> be to allow reference objects from schemas different than source and in
> case some error happen it stop the process. This behavior should be
> documented.

The more I think about it, the more it seems like the safest approach.
As I mentioned upthread, the user might otherwise end up with pretty
much useless tables and the pleasure of having to drop them manually :)

> In case of e.g table partitions which the parent is in different schema
> the overlap error will happen and the the process will stop. For another
> cases like types in different schema it will work normally.

+1

Best, Jim



pgsql-hackers by date:

Previous
From: KAZAR Ayoub
Date:
Subject: Re: Speed up COPY TO text/CSV parsing using SIMD
Next
From: Jeff Davis
Date:
Subject: Re: Expanding HOT updates for expression and partial indexes