Looks like this thread does not move forward. So I'm posting my thoughts to bump it.
On Wed, 4 Dec 2024 at 01:07, Tom Lane <t...@sss.pgh.pa.us> wrote: > I'm totally willing to throw that possibility overboard > permanently in order to expand the set of creatable object types > without introducing a ton of restrictions and weird behaviors. > What do you think? Im +1 on this, but can you please elaborate, which exact objects cannot be created now? What will be expanded after v2-0002-Dont_try-to-reoder....? > PS: if we were really excited about allowing circular FKs to be > made within CREATE SCHEMA, a possible though non-standard answer > would be to allow ALTER TABLE ADD CONSTRAINT as a <schema element>. That's a nice feature to have by itself? -- Best regards, Kirill Reshke