Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4854D632A0D for ; Tue, 27 Jul 2010 17:50:36 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 97224-09 for ; Tue, 27 Jul 2010 20:50:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id DB0FB633FC9 for ; Tue, 27 Jul 2010 17:50:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o6RKoPus013846; Tue, 27 Jul 2010 16:50:25 -0400 (EDT) To: =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= cc: pgsql-sql@postgresql.org Subject: Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them In-reply-to: References: Comments: In-reply-to =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= message dated "Fri, 23 Jul 2010 14:53:11 +0200" Date: Tue, 27 Jul 2010 16:50:24 -0400 Message-ID: <13845.1280263824@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/107 X-Sequence-Number: 34420 =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > I have defined an BEFORE UPDATE trigger. The trigger catch every update, > change some columns of the new row, make an insert of the new row and > returns null to abort the update. Why in the world would you do that? Just return the modified row from the trigger and let the update proceed normally. regards, tom lane