From: Tom Lane <tgl@sss.pgh.pa.us>
To: Noah Misch <noah@leadboat.com>
Cc: jian he <jian.universality@gmail.com>
Cc: Kirill Reshke <reshkekirill@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: CREATE SCHEMA ... CREATE DOMAIN support
Date: Fri, 04 Sep 2026 15:30:38 -0400
Message-ID: <1584523.1788550238@sss.pgh.pa.us> (raw)
In-Reply-To: <20260904180712.cc.noahmisch@microsoft.com>
References: <3819788.1775241322@sss.pgh.pa.us>
<841583.1775414546@sss.pgh.pa.us>
<944307.1775420103@sss.pgh.pa.us>
<CACJufxEwkAJuCutLQdsxCOJkAvDS=9KgbphMVkXtQP8te=nciA@mail.gmail.com>
<1199006.1775444695@sss.pgh.pa.us>
<1838711.1775503188@sss.pgh.pa.us>
<20260904002924.a7.noahmisch@microsoft.com>
<1504966.1788483626@sss.pgh.pa.us>
<20260904035154.0b.noahmisch@microsoft.com>
<1566169.1788531712@sss.pgh.pa.us>
<20260904180712.cc.noahmisch@microsoft.com>
Noah Misch <noah@leadboat.com> writes:
> On Fri, Sep 04, 2026 at 10:21:52AM -0400, Tom Lane wrote:
>> What would you have us do differently?
> I recommend reverting the v19 CREATE SCHEMA changes, unfortunately. The
> thread started with what smelled like low-hanging fruit: let users write
> "CREATE SCHEMA myschema CREATE DOMAIN mydomain" instead of "CREATE SCHEMA
> myschema; CREATE DOMAIN myschema.mydomain". That led to a9c350d silently
> changing the meaning of CREATE SCHEMA statements that v18 already accepts.
> Since the benefit of supporting "CREATE SCHEMA myschema CREATE DOMAIN
> mydomain" is so modest, it doesn't take much of a problem to outweigh that
> benefit.
Well, you have a point. There's pretty nearly nothing that's
well-designed about CREATE SCHEMA subcommands: as you say, the syntax
is shaky, and the namespace visible to subcommands is unclear, and
the whole business of re-ordering subcommands is debatable, and even
if all those things were fixed the benefit of the entire feature is
marginal. So maybe we should just say that our legacy implementation
is what it is and we will mark it deprecated rather than putting any
effort into improving it. I'd like to see more than one vote in favor
of that before I do it, though.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, noah@leadboat.com, jian.universality@gmail.com, reshkekirill@gmail.com, peter@eisentraut.org, pgsql-hackers@lists.postgresql.org
Subject: Re: CREATE SCHEMA ... CREATE DOMAIN support
In-Reply-To: <1584523.1788550238@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox