Postgres Pro
Downloads
Home   >   mailing lists

Re: After Trigger assignment to NEW - Mailing list pgsql-sql

From Tom Lane
Subject Re: After Trigger assignment to NEW
Date
Msg-id 3649.1140797162@sss.pgh.pa.us
Whole thread Raw
In response to After Trigger assignment to NEW  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: After Trigger assignment to NEW  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: After Trigger assignment to NEW  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
Tree view 
Achilleus Mantzios <achill@matrix.gatewaynet.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

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: After Trigger assignment to NEW
Next
From: Alvaro Herrera
Date:
Subject: Re: After Trigger assignment to NEW