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

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:
> 
>   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.

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?

Thx, Oliver Brueck