From: Michael Fuhr <mike@fuhr.org>
To: Oliver Brück <oliver.brueck@waagner-biro.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: No triggers visible for different user in information_schema.triggers
Date: Thu, 17 Feb 2005 10:43:32 -0700
Message-ID: <20050217174332.GA26546@winnie.fuhr.org> (raw)
In-Reply-To: <4214BF20.1010908@waagner-biro.com>
References: <4214BF20.1010908@waagner-biro.com>
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 as:
The view triggers contains all triggers defined in the current
database that are owned by the current user. (The owner of the
table is the owner of the trigger.)
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:
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.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
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: mike@fuhr.org, oliver.brueck@waagner-biro.com
Subject: Re: No triggers visible for different user in information_schema.triggers
In-Reply-To: <20050217174332.GA26546@winnie.fuhr.org>
* 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