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