Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with NEW.* in triggers - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Problems with NEW.* in triggers
Date
Msg-id 200311041452.34214.josh@agliodbs.com
Whole thread Raw
In response to Problems with NEW.* in triggers  (Jamie Lawrence <postgres@jal.org>)
List pgsql-sql
Tree view 
Jamie,

> Any thoughts on what I'm doing wrong??

Yes.  If you want to modify the new data, you need to use a BEFORE trigger.
AFTER triggers can't modify NEW, just read it.

--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with NEW.* in triggers
Next
From: Jamie Lawrence
Date:
Subject: Re: Problems with NEW.* in triggers