Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x4KzD-0074zN-1w for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2026 16:17:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x4KzA-00GOVT-2A for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2026 16:17:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x4KzA-00GOVL-16 for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2026 16:17:20 +0000 Received: from mail-qt1-x82e.google.com ([2607:f8b0:4864:20::82e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x4Kz8-00000003nXG-0Gq9 for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2026 16:17:20 +0000 Received: by mail-qt1-x82e.google.com with SMTP id d75a77b69052e-53091987029so28747071cf.3 for ; Wed, 09 Sep 2026 09:17:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1788970636; x=1789575436; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=D7yJ4kFMu3521EuPbXQZMFYjoYBvjC0bCIMmBJxxGW8=; b=YSh7f5dbMl8biMtW4ocACZTK9zo5qkEY1CNZVppAYFmEAAid/TtcA1DNEWRIVe6AX6 KflMzdAzvmobydX/TVR+CVD1j5s7jcyCOluO+fIJ8ISj8UdeYO4CfNfog3ZZBzxbCHOw FLsy0IC1mRsAXmv/3ZLDf/6fHZs0P5/blF4L6jFZmQos1OwEA+48KaF//r4VSnqhPa80 KoLLwSyPtPmpmT4K6wKVAgIURHyfHVGSQvBsD68H3y3zyCrHIccZoD39WdRusuLRfmk5 /O9pg5+TCSAXwURD9oCdzMeWcdgBzyv7l8I2Db+0qhvlyueBgJEYCFIL5XsK1M3T2iAz VbrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1788970636; x=1789575436; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=D7yJ4kFMu3521EuPbXQZMFYjoYBvjC0bCIMmBJxxGW8=; b=AMV0bdOLof+n+myHiToYFAxETpSx80MsTAsdjtKPoB6bILvAUXs3M8qziWFLglfPic WOKZSIQrVbC4+DJPj3BdpiBO4XR7VzxANiNGz3Tj3ezZuELmfEAy5iN8ci8AI0XuY9Bg 2cxsb1qR1k04mMnuLPmAe0kzUyjDqa+RhXl4zsxx0WjVOmfgauSNE4Wvr0wCPM9pturz W81N7EXeFRNBwF/W+xqSRSMx1CM/rkvxhHNaD3SDBhAbbMeU28f3lFdmUHFkch/PP2aq c5ftGMJ6EPbc69++8IQNhk4cg/etpbddJwegwpNqQ33Wf38Pe7ko9r1OdUTj+T2ZimRJ EHLQ== X-Forwarded-Encrypted: i=1; AKwUvBxK5KRpXarzgRvXnwZT2rj1kSL1rCR58zVjCh+KlXoMIeTpp3Hw84WATPjyjXRZpgVbdixgAoFqjBCk0i9W@lists.postgresql.org X-Gm-Message-State: AFuF++lxh54KHoKbzWP0L1hJH5OEluE2737iBrTO7TrZEbkKn19lweUa 5LGksxtApLnw24eQ6FOpdG6LFv3VH03EfHQenJmnLgNJJZ3zDpeyUaGg X-Gm-Gg: AYBFou0vgvgYpugnUaKmOPK43xzWPG46JaSFatld9HmdsL6X6lbbGEZzw1wHD4rdcHH oFJ/lFW2OdVrp7z+UOLLX1Sq0p1lDVeYMG9ZEjPz2bVTR+9PGE31ATegqe0G3gLPhaqIeUQ5gmF BuShLgCNB+EnSpSHy/q7RkGs4L754J7twgPZxyTJVLK2PvNNZM1OZAiDuSOX1tD4ZVZfKQFxskE m3OHhidlLhjj75siKKmXl0plAIbafbD8Cfsp3d3QfeX/2M4MZK8m60XJASa3tmo5pkZj4fi/BGf Byurfln7/qJ51sRmvD3rv/JUibwRXzGhc7yDn4nn3MsvehWKWJaZFqXKll2cgouGAA6xZ1UsJFI Vx+fPbPoafA41vgu76lYD7yMvdJgtLccK9xyZm8Ju59GIcbW1VxxWq7S1umIsB90Kr8ZygDaikl X+n0oPNkE7Qx2S5a14aIbqbp0+TvRpaAcPOGsWp1G+d7m0qfA0oK8VbnRig5jy65qzVg1bLYRo+ E+80VdCcKRsX0FfBQYVRT3daYjgg3iOe4AMLF2vAjtI7vijOSPsCOpLIawijc+qLcmrAM49MftX dlpkNl6c02giP+7Iq3HFTSLpPR9z0D5Kj8cdgQ== X-Received: by 2002:a05:622a:1114:b0:517:6550:2a0 with SMTP id d75a77b69052e-5305482cdbemr412773281cf.19.1788970635920; Wed, 09 Sep 2026 09:17:15 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id d75a77b69052e-5305413d7f8sm142534951cf.14.2026.09.09.09.17.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 09 Sep 2026 09:17:15 -0700 (PDT) Date: Wed, 9 Sep 2026 11:17:13 -0500 From: Nathan Bossart To: Heikki Linnakangas Cc: Tom Lane , Noah Misch , jian he , Kirill Reshke , Peter Eisentraut , PostgreSQL Hackers Subject: Re: CREATE SCHEMA ... CREATE DOMAIN support Message-ID: References: <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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <57046562-8fe6-4663-b4d7-724d195f38f7@iki.fi> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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