From: Oliver Brück <oliver.brueck@waagner-biro.com>
To: pgsql-sql@postgresql.org
Subject: No triggers visible for different user in information_schema.triggers
Date: Thu, 17 Feb 2005 16:58:24 +0100
Message-ID: <4214BF20.1010908@waagner-biro.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliver.brueck@waagner-biro.com
Subject: Re: No triggers visible for different user in information_schema.triggers
In-Reply-To: <4214BF20.1010908@waagner-biro.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox