X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 09EBA9DCB76 for ; Tue, 29 Nov 2005 19:24:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35319-10 for ; Tue, 29 Nov 2005 19:24:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com [216.136.174.114]) by postgresql.org (Postfix) with SMTP id 004519DCAD4 for ; Tue, 29 Nov 2005 19:24:51 -0400 (AST) Received: (qmail 38791 invoked from network); 29 Nov 2005 23:24:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=Yahoo.com; h=Received:Message-ID:Date:From:User-Agent:X-Accept-Language:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=I81y2+p1PeGSQHzbI0DetWoAcDFzUch1oVnRctlYfK5AEz9zdLlF+jf7nYIhLiqbE06CIjadmpzcm/9w4qzi3cePkps+hHQ3z9IpfX6hMOl0a++4IlfRrbE3Q/e0vLn1Yfy9kEsf9F2wntolNJgBzqnWY7E4lIgmp1FHLvmb/Mo= ; Received: from unknown (HELO jupiter.black-lion.info) (janwieck@68.80.245.191 with login) by smtp017.mail.yahoo.com with SMTP; 29 Nov 2005 23:24:49 -0000 Received: from [172.21.8.23] (mars.black-lion.info [192.168.192.101]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id jATNOj1o083557; Tue, 29 Nov 2005 18:24:45 -0500 (EST) (envelope-from JanWieck@Yahoo.com) Message-ID: <438CE34E.1040507@Yahoo.com> Date: Tue, 29 Nov 2005 18:25:02 -0500 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Achilleus Mantzios CC: Neil Saunders , "Leif B. Kristensen" , pgsql-sql@postgresql.org Subject: Re: Triggers References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.348 required=5 tests=[AWL=-0.131, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.348 X-Spam-Level: X-Archive-Number: 200511/279 X-Sequence-Number: 23530 On 11/23/2005 3:44 AM, Achilleus Mantzios wrote: > O Neil Saunders έγραψε στις Nov 22, 2005 : > >> And change AFER INSERT to BEFORE INSERT > > 1) it doesnt make any difference since we are updating > a different table than the trigger's one In this particular case it doesn't. In general, another BEFORE trigger can still modify the new row, so your trigger might not see the final values in NEW. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #