On Wed, Feb 23, 2005 at 09:05:39AM +0100, Oliver Brück wrote:
> While PostgreSQL implements the SQL:1999 behaviour, is there any way to
> check if a certain trigger already has been created, though that trigger
> is owned by another user?
See the "System Catalogs" chapter in the documentation,
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.
Whil
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.trigge
