Am Donnerstag, 17. Februar 2005 18:43 schrieb Michael Fuhr:
> SQL:2003 (Working Draft) says:
>
> Identify the triggers on tables in this catalog that are accessible
> to a given user or role.
>
> Apparently PostgreSQL implements the SQL:1999 specification of
> information_schema.triggers.
While that is true, superuserdom consistently does not play any role in the
information schema for the purpose of figuring out what is accessible to a
certain user. This may be considered a bug, but it would also create
inconsistencies because the state "accessible to" is defined by other
information schema tables where superuserdom cannot be represented.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
