| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | Neil Saunders <n(dot)j(dot)saunders(at)gmail(dot)com>, "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Triggers |
| Date: | 2005-11-29 23:25:02 |
| Message-ID: | 438CE34E.1040507@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NosyMan | 2005-11-30 09:18:28 | Help needed |
| Previous Message | Leif B. Kristensen | 2005-11-29 16:47:49 | Re: Strange bug |