On Sun, Mar 27, 2005 at 07:28:21PM -0500, Kyrill Alyoshin wrote:
>
> I cannot get AFTER INSERT (or UPDATE for that matter) triggers to work.
> The same code works perfectly fine for BEFORE triggers.
You're trying to modify the record but it's too late in an AFTER
trigger. See the "Triggers" chapter in the documentation:
The return value is ignored for row-level triggers fired after
an operation, and so they may as well return NULL.
The PL/pgSQL "Trigger Procedures" section repeats the above:
The return value of a BEFORE or AFTER statement-level trigger
or an AFTER row-level trigger is always ignored; it may as well
be null.
http://www.postgresql.org/docs/8.0/interactive/triggers.htmlhttp://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/