Re: Re: postgresql rule bug

From: "Mark Hollomon" <mhh(at)nortelnetworks(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Coranth Gryphon <gryphon(at)healer(dot)com>, scrappy(at)hub(dot)org, Jan Wieck <wieck(at)debis(dot)com>, bugs(at)postgresql(dot)org
Subject: Re: Re: postgresql rule bug
Date: 2000-04-12 07:45:48
Message-ID: 38F429AC.8191A34B@americasm01.nt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
>
> Coranth Gryphon <gryphon(at)healer(dot)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(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2000-04-12 10:24:41 Re: Minimal patches for PostgreSQL 7.0b3 on NetBSD/alpha 1.4.1....
Previous Message Raul Chirea 2000-04-12 02:49:44 Foreign keys breaks tables permissions