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 the information_schema.triggers view. USER2 also can create and drop these triggers, but does not see any entry in information_schema.triggers. The query
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.
What is my fault?
Kind regards, Oliver Brueck
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
