Re: No triggers visible for different user in information_schema.triggers

From: Oliver Brück <oliver(dot)brueck(at)waagner-biro(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>, peter_e(at)gmx(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: No triggers visible for different user in information_schema.triggers
Date: 2005-02-23 08:05:39
Message-ID: 421C3953.4000408@waagner-biro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-02-23 08:55:20 Re: No triggers visible for different user in information_schema.triggers
Previous Message Richard Huxton 2005-02-23 08:02:48 Re: Speeds using a transaction vrs not