X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 57E6FD1B233 for ; Fri, 21 May 2004 17:47:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35334-01 for ; Fri, 21 May 2004 17:47:02 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id CD45BD1B1A9 for ; Fri, 21 May 2004 17:46:59 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i4LJ9c9U021919; Fri, 21 May 2004 15:09:38 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i4LKkqN01963; Fri, 21 May 2004 16:46:57 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id L2VRZBB4; Fri, 21 May 2004 16:46:50 -0400 Subject: Re: My connection only - Disable Trigger From: Robert Treat To: Eko Pranoto Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 21 May 2004 16:46:51 -0400 Message-Id: <1085172411.29461.1554.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/235 X-Sequence-Number: 13551 On Fri, 2004-05-21 at 04:49, Eko Pranoto wrote: > > My friends, I apologize if my english language is bad. > > I have question about trigger.. > > How to disable trigger, ONLY for my connection > NOT others people connection (they will use the trigger) > any solution ? > One way would be to have the trigger function check for the CURRENT_USER setting and then act accordingly. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL