X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 889128B9D42 for ; Wed, 23 Feb 2005 08:07:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99826-09 for ; Wed, 23 Feb 2005 08:07:41 +0000 (GMT) Received: from secure.waagner-biro.com (secure.waagner-biro.com [213.239.200.104]) by svr1.postgresql.org (Postfix) with ESMTP id 0B68F8B9CEC for ; Wed, 23 Feb 2005 08:07:41 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by secure.waagner-biro.com (Postfix) with ESMTP id AC9857F50D; Wed, 23 Feb 2005 09:07:39 +0100 (CET) Received: by secure.waagner-biro.com (Postfix, from userid 65534) id 432467E8AE; Wed, 23 Feb 2005 09:07:39 +0100 (CET) Received: from gw2.guddland.lu (pppoe240-static-luxdsl-072.pt.lu [213.135.240.72]) by secure.waagner-biro.com (Postfix) with ESMTP id 0549F7D39C; Wed, 23 Feb 2005 09:07:39 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by gw2.guddland.lu (Postfix) with ESMTP id EEA122801A; Wed, 23 Feb 2005 09:07:37 +0100 (CET) Received: from [193.168.48.90] (cat90.guddland.lu [193.168.48.90]) by gw2.guddland.lu (Postfix) with ESMTP id 43E3527FEF; Wed, 23 Feb 2005 09:07:37 +0100 (CET) Message-ID: <421C3953.4000408@waagner-biro.com> Date: Wed, 23 Feb 2005 09:05:39 +0100 From: =?ISO-8859-1?Q?Oliver_Br=FCck?= Organization: Waagner Biro Luxembourg Stage Systems SA User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Michael Fuhr , peter_e@gmx.net Cc: pgsql-sql@postgresql.org Subject: Re: No triggers visible for different user in information_schema.triggers References: <4214BF20.1010908@waagner-biro.com> <20050217174332.GA26546@winnie.fuhr.org> In-Reply-To: <20050217174332.GA26546@winnie.fuhr.org> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/267 X-Sequence-Number: 20377 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