Re: pgsql/src backend/catalog/aclchk.c backend/cat ...

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