Re: After Trigger assignment to NEW

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: After Trigger assignment to NEW
Date: 2006-02-24 16:06:02
Message-ID: 3649.1140797162@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> Is there a reason that the NEW values should remain unchanged in AFTER
> row triggers?

By definition, an AFTER trigger is too late to change what was stored.
Use a BEFORE trigger.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2006-02-24 16:44:08 After Trigger assignment to NEW
Previous Message A. Kretschmer 2006-02-24 12:43:46 Re: "Installing" dbLink