Re: [SQL] No triggers visible for different user in information_schema.triggers

[Oliver Brück]

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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match