Hello again,
thanks a lot for the fast and significant help.
Michael Fuhr schrieb:
On Thu, Feb 17, 2005 at 04:58:24PM +0100, Oliver Brück wrote:
[SNIP]
SQL:1999 defines the TRIGGERS view as:
Identify the triggers in this catalog that are owned by a given
user.
SQL:2003 (Working Draft) says:
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
Hello,
I am using a postgres 7.4 dbms, a single database DB in the public
scheme and two database users USER1 and USER2, both of them having
superuser priviliges.
USER1 is owner of all tables in the database DB. I have defined triggers
on some tables as user USER1, and all of them are shown in
On Thu, Feb 17, 2005 at 04:58:24PM +0100, Oliver Brück wrote:
SELECT * FROM information_schema.triggers;
returns an empty result. I thought this is caused by a lack of
priviliges, but USER1 as well as USER2 are superusers.
The PostgreSQL documentation defines information_schema.triggers