Small clarification in "34.41. schemata"

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Small clarification in "34.41. schemata"
Date: 2013-01-10 00:35:10
Message-ID: CAB8KJ=g317u8GVyoi+E8cByOGVa+iNVsriTgC+XFA-k2wqpCTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

The documentation says:

The view schemata contains all schemas in the current database that
are owned by a currently enabled role.

( http://www.postgresql.org/docs/9.2/static/infoschema-schemata.html )

However it shows all schemas if the user is a superuser, regardless of
whether the schema is owned by the superuser.

Does the documentation need clarifying? I'd suggest something like:

The view schemata contains all schemas in the current database that
are owned by a currently enabled role, or all schemas if the currently
enabled role is a superuser.

Regards

Ian Lawrence Barwick

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2013-01-10 01:56:35 Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: Small clarification in "34.41. schemata")
Previous Message Bruce Momjian 2013-01-09 22:10:56 Re: PostgreSQL docs in ePub format

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2013-01-10 00:38:36 Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL
Previous Message Simon Riggs 2013-01-09 23:40:28 Re: Index build temp files