Horton

Re: Re: postgresql rule bug

Mark Hollomon <mhh@nortelnetworks.com>

View thread
From: "Mark Hollomon" <mhh@nortelnetworks.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Coranth Gryphon <gryphon@healer.com>, scrappy@hub.org, Jan Wieck <wieck@debis.com>, bugs@postgresql.org
Date: 2000-04-12T07:45:48Z
Lists: pgsql-bugs 
Tom Lane wrote:
> 
> Coranth Gryphon <gryphon@healer.com> writes:
> > CREATE RULE T_CommentCreation
> >   AS ON INSERT TO T_Comments
> >   DO INSERT INTO T_CommentHistory
> >      VALUES (new.id_note, CURRENT_TIMESTAMP, 'create')

Untested suggestion -

Try using currval('T_Comments_id_note_seq') instead.

-- 

Mark Hollomon
mhh@nortelnetworks.com
ESN 451-9008 (302)454-9008