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 1CC068B9E04 for ; Thu, 17 Feb 2005 15:59:17 +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 49607-06 for ; Thu, 17 Feb 2005 15:59:10 +0000 (GMT) Received: from secure.waagner-biro.com (secure.waagner-biro.com [213.239.200.104]) by svr1.postgresql.org (Postfix) with ESMTP id 0385A8BA2CB for ; Thu, 17 Feb 2005 15:59:03 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by secure.waagner-biro.com (Postfix) with ESMTP id 0EA927EB27 for ; Thu, 17 Feb 2005 16:59:01 +0100 (CET) Received: by secure.waagner-biro.com (Postfix, from userid 65534) id 98A4F7EB23; Thu, 17 Feb 2005 16:59:00 +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 5F8E57EB1D for ; Thu, 17 Feb 2005 16:59:00 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by gw2.guddland.lu (Postfix) with ESMTP id DE75F28514 for ; Thu, 17 Feb 2005 16:58:59 +0100 (CET) Received: from [193.168.48.90] (cat90.guddland.lu [193.168.48.90]) by gw2.guddland.lu (Postfix) with ESMTP id 8B4A12814E for ; Thu, 17 Feb 2005 16:58:59 +0100 (CET) Message-ID: <4214BF20.1010908@waagner-biro.com> Date: Thu, 17 Feb 2005 16:58:24 +0100 From: =?ISO-8859-15?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: pgsql-sql@postgresql.org Subject: No triggers visible for different user in information_schema.triggers X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit 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/189 X-Sequence-Number: 20300 Hello, I am using a postgres 7.4 dbms, a single database DB in the public scheme and two database users USER1 and USER2, both of them having superuser priviliges. USER1 is owner of all tables in the database DB. I have defined triggers on some tables as user USER1, and all of them are shown in the information_schema.triggers view. USER2 also can create and drop these triggers, but does not see any entry in information_schema.triggers. The query SELECT * FROM information_schema.triggers; returns an empty result. I thought this is caused by a lack of priviliges, but USER1 as well as USER2 are superusers. What is my fault? Kind regards, Oliver Brueck