Re: No triggers visible for different user in information_schema.triggers - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: No triggers visible for different user in information_schema.triggers
Date
Msg-id 20050223085520.GA23853@winnie.fuhr.org
Whole thread Raw
In response to Re: No triggers visible for different user in information_schema.triggers  (Oliver Brück <oliver.brueck@waagner-biro.com>)
List pgsql-sql
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, in particular
the page for pg_trigger.  It can also be instructive to run psql with
the -E option or execute "\set ECHO_HIDDEN" to make psql show the
queries it executes for commands like "\d tablename".

What are you trying to do?  Why do you want to look for a particular
trigger?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: Oliver Brück
Date:
Subject: Re: No triggers visible for different user in information_schema.triggers
Next
From: "Thomas Braad Toft"
Date:
Subject: PostgreSQL ignores my indexes