Emit warning when adding pg_catalog on db-schemas #4359
Description
Oh.. That explains it. What was the rationale for this decision?
We did it that way to avoid exposing sensitive information, and all roles have implicit access to information_schema and pg_catalog, IIRC revoking SELECT privileges to those schemas can break postgres in unexepected ways.
Additionally it would be nice to get a warning when it is explicitly added to db-schemas instead of silently ignoring it.
Great idea. We should do that and also document this decision.
Originally posted by @steve-chavez in #4252 (reply in thread)