| 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: | Whole Thread | Raw Message | 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 |