Re: 'pg_global' cannot be used as default_tablespace. - Mailing list pgsql-docs

"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