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
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 |
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 |