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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]