On 1/9/13 8:56 PM, Tom Lane wrote: > However, it seems to me that this behavior is actually wrong for our > purposes, as it represents a too-literal reading of the spec. The SQL > standard has no concept of privileges on schemas, only ownership. > We do have privileges on schemas, so it seems to me that the consistent > thing would be for this view to show any schema that you either own or > have some privilege on. That is the test should be more like > > pg_has_role(n.nspowner, 'USAGE') > OR has_schema_privilege(n.oid, 'CREATE, USAGE') > > As things stand, a non-superuser won't see "public", "pg_catalog", > nor even "information_schema" itself in this view, which seems a > tad silly.
I agree it would make sense to change this. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers