X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BCCA9D1B48D for ; Fri, 16 Jan 2004 10:26:37 +0000 (GMT) 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 07967-03 for ; Fri, 16 Jan 2004 06:26:08 -0400 (AST) Received: from noon.pghoster.com (noon.pghoster.com [64.246.0.64]) by svr1.postgresql.org (Postfix) with ESMTP id 03794D1B446 for ; Fri, 16 Jan 2004 06:26:06 -0400 (AST) Received: from [61.5.0.51] (helo=winxp) by noon.pghoster.com with asmtp (Exim 4.24) id 1AhRB0-00022Z-BB; Fri, 16 Jan 2004 04:26:06 -0600 Message-ID: <019c01c3dc1b$17ba7830$7f44053d@winxp> From: "Chris Travers" To: "pginfo" , References: <400691EA.96598C34@t1.unisoftbg.com> Subject: Re: Trigger question Date: Fri, 16 Jan 2004 17:19:24 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - noon.pghoster.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - travelamericas.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/165 X-Sequence-Number: 5340 > Exists in pg any way to define the trigger execution only if I have > changes on some fields? No, but you chould check for those fields and return if no changes have been made. Depending on how intensive the trigger is, this might help. You may also want to look at statement-level triggers or conditional rules. Best Wishes, Chris Travers