Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Problems with NEW.* in triggers
Date
Msg-id 27275.1067991046@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with NEW.* in triggers  (Jamie Lawrence <postgres@jal.org>)
Responses Re: Problems with NEW.* in triggers  (Jamie Lawrence <jal@jal.org>)
List pgsql-sql
Tree view 
Jamie Lawrence <postgres@jal.org> writes:
> I don't understand why moddate isn't getting set to now() in the above.

Josh fingered the problem there --- you need a BEFORE trigger if you
want to affect the data that will be stored.  I had missed that little
mistake :-(
        regards, tom lane

pgsql-sql by date:

Previous
From: Jamie Lawrence
Date:
Subject: Re: Problems with NEW.* in triggers
Next
From: Michael Glaesemann
Date:
Subject: Re: query assistance