From: Nathan Bossart <nathandbossart@gmail.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: 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: Wed, 9 Sep 2026 11:17:13 -0500
Message-ID: <aqGGiZfONuhkd25F@nathan> (raw)
In-Reply-To: <57046562-8fe6-4663-b4d7-724d195f38f7@iki.fi>
References: <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>
<1584523.1788550238@sss.pgh.pa.us>
<57046562-8fe6-4663-b4d7-724d195f38f7@iki.fi>
On Wed, Sep 09, 2026 at 06:53:58PM +0300, Heikki Linnakangas wrote:
> On 04/09/2026 22:30, Tom Lane wrote:
>> 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.
>
> Reverting seems like the safest thing to do. This is a really niche thing,
> but whatever behavior we pick, we'll be stuck with it for a long time. If
> we're not 100% certain about the new behavior, better to take a step back
> and discuss and design it with more time.
+1
--
nathan
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: nathandbossart@gmail.com, hlinnaka@iki.fi, 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: <aqGGiZfONuhkd25F@nathan>
* 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