Re: Triggers - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Triggers
Date
Msg-id 438CE34E.1040507@Yahoo.com
Whole thread Raw
In response to Re: Triggers  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
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 #


pgsql-sql by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Re: Strange bug
Next
From: NosyMan
Date:
Subject: Help needed