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

From Jamie Lawrence
Subject Re: Problems with NEW.* in triggers
Date
Msg-id 20031105001653.GD2879@clueinc.net
Whole thread Raw
In response to Re: Problems with NEW.* in triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Tue, 04 Nov 2003, Tom Lane wrote:

> 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 :-(

Yep. Many thanks to both of you.

-j


-- 
Jamie Lawrence                                        jal@jal.org
If built in great numbers, motels will be used for nothing but illegal
purposes.   - J. Edgar Hoover




pgsql-sql by date:

Previous
From: Marcus Krause
Date:
Subject: No output while using PEAR DB & formatted time-string
Next
From: alban
Date:
Subject: 7.3 : how add user when last user have lost 'createuser' option