Horton

CREATE SCHEMA ... CREATE DOMAIN support

Kirill Reshke <reshkekirill@gmail.com>

View thread View on postgr.es
From: Kirill Reshke <reshkekirill@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-11-12T12:54:46Z
Lists: pgsql-hackers

Attachments

Hi hackers!

This copy of my reply mail from pgsql-general[0], & [1] which was held
for moderation for some reason.

Here it goes as-is :

== begin
Hi Álvaro, thanks for the detailed explanation.

So, IIUC you are suggesting to support SQL standard features before
any work with PostgreSQL extension.
Ok, I will try to go this way. PFA patch implementing CREATE DOMAIN
support for CREATE SCHEMA statement.
Of all other options, CREATE DOMAIN support looks like the most stranfoward one.

Patch obviously leaks doc & regression tests, but I'm posting it to
see if this contribution is needed in PostgreSQL

== end


[0] https://www.postgresql.org/message-id/CALdSSPgxcRkooZ2iQ5A7XhYoexVAdbiT6znZDqJTE8hxUVjz_A%40mail.gmail.com

[1] https://www.postgresql.org/message-id/202411111009.ckna4vp7ahyk%40alvherre.pgsql
-- 
Best regards,
Kirill Reshke

Commits

  1. Don't try to re-order the subcommands of CREATE SCHEMA.

  2. Execute foreign key constraints in CREATE SCHEMA at the end.

  3. Support more object types within CREATE SCHEMA.