Re: CREATE SCHEMA ... CREATE DOMAIN support

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: jian he <jian.universality@gmail.com>

Cc: Kirill Reshke <reshkekirill@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-04-05T22:05:41Z

Lists: pgsql-hackers

Attachments

v13-0001-Don-t-try-to-re-order-the-subcommands-of-CREATE-.patch (text/x-diff) patch v13-0001
v13-0002-Execute-foreign-key-constraints-in-CREATE-SCHEMA.patch (text/x-diff) patch v13-0002
v13-0003-Support-more-object-types-within-CREATE-SCHEMA.patch (text/x-diff) patch v13-0003

I wrote:
> Here's a revised patchset that I think is pretty close to committable.

The cfbot reminded me that I'd failed to check whether the regression
test outputs are stable across different collations.  Grumble.

Fixed that, and rewrote the changes in create_schema.sgml as I'd been
speculating about earlier.

			regards, tom lane

Commits

Don't try to re-order the subcommands of CREATE SCHEMA.
- a9c350d9ee66 19 (unreleased) landed
Execute foreign key constraints in CREATE SCHEMA at the end.
- 404db8f9edbb 19 (unreleased) landed
Support more object types within CREATE SCHEMA.
- d516974840f4 19 (unreleased) landed