Re: Re: postgresql rule bug - Mailing list pgsql-bugs

From Mark Hollomon
Subject Re: Re: postgresql rule bug
Date
Msg-id 38F429AC.8191A34B@americasm01.nt.com
Whole thread Raw
In response to Re: postgresql rule bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-bugs by date:

Previous
From: Raul Chirea
Date:
Subject: Foreign keys breaks tables permissions
Next
From: Peter Eisentraut
Date:
Subject: Re: Minimal patches for PostgreSQL 7.0b3 on NetBSD/alpha 1.4.1....