Re: pgsql/src backend/catalog/aclchk.c backend/cat ... - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql/src backend/catalog/aclchk.c backend/cat ...
Date
Msg-id 11050.1018649292@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql/src backend/catalog/aclchk.c backend/cat ...  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-committers
Peter Eisentraut <peter_e@gmx.net> writes:
> But the schema for system catalogs is supposed to be called
> definition_schema.

(1) AFAICT from the spec, DEFINITION_SCHEMA is not allowed to be
accessed directly from SQL statements, thus whether it really exists
or not is a matter of theology, not an interesting question for spec
conformance.

(2) In our case there are multiple special namespaces (pg_catalog,
pg_toast, pg_temp_XXX, maybe some more in the future) and so having
just one reserved schema name isn't going to do anyway.  It seems
appropriate to move our traditional "pg_ prefix is reserved" notion
over to the domain of schema names, even though we no longer have to
have it at the table level.

            regards, tom lane

pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgsql/src backend/catalog/aclchk.c backend/cat ...
Next
From: momjian@postgresql.org (Bruce Momjian - CVS)
Date:
Subject: pgsql/doc TODO