Horton

Re: CREATE SCHEMA ... CREATE DOMAIN support

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: jian he <jian.universality@gmail.com>
Cc: Kirill Reshke <reshkekirill@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-11-27T03:47:24Z
Lists: pgsql-hackers 
jian he <jian.universality@gmail.com> writes:
> one issue i still have is:
> CREATE SCHEMA regress_schema_2 AUTHORIZATION CURRENT_ROLE
>   create domain ss1 as ss
>   create domain ss as text;
> ERROR:  type "ss" does not exist
> the error message seems not that OK,
> if we can point out the error position, that would be great.

That doesn't happen in the base case either:

regression=# create domain ss1 as ss;
ERROR:  type "ss" does not exist

I doubt that fixing it should be part of this patch.

			regards, tom lane

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.