From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Bruce Momjian <bruce@momjian.us>,
        "zhoushulin1992@gmail.com" <zhoushulin1992@gmail.com>,
        "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: 'pg_global' cannot be used as default_tablespace.
In-reply-to: 
 <CAKFQuwY+s2BC2jZ4ZVwM7j6BXJ0zOCecOOfEM7_0szvVY_9deA@mail.gmail.com>
References: <160499688847.25495.8682880307938679648@wrigleys.postgresql.org>
 <ZULN_DUmssiXednO@momjian.us>
 <CAKFQuwY+s2BC2jZ4ZVwM7j6BXJ0zOCecOOfEM7_0szvVY_9deA@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Wed, 01 Nov 2023 15:26:49 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2878750.1698877957.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Wed, 01 Nov 2023 18:32:37 -0400
Message-ID: <2878751.1698877957@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2878751.1698877957%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Wednesday, November 1, 2023, Bruce Momjian <bruce@momjian.us> wrote:
>> Did you want an error from the SET command?

> That would probably be a decent addition but the request was for us to add
> “it is not permissible to specify the pg_global tablespace for either
> default_tablespace or temp_tablespace”.  In the tablespace section per the
> request but maybe also within the settings definition section.

But it *is* permissible, unless we add code to reject it during
SET as Bruce mentioned.  Which seems fairly pointless to me.  It's not
like there is anything unclear about the CREATE TABLE error message.

			regards, tom lane