Re: BUG #5081: ON INSERT rule does not work correctly - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5081: ON INSERT rule does not work correctly
Date
Msg-id 603c8f070909270646l1620fc93x9102651da59c5d5d@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5081: ON INSERT rule does not work correctly  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5081: ON INSERT rule does not work correctly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Stefan" <sb@drbott.de> writes:
>> The problem is that if it is no record in the table, it seems that first=
 the
>> INSERT command is issued and after that the UPDATE command is issued, to=
o.
>
> Well, yeah. =A0That's exactly how it's documented to work: an ON INSERT
> rule is executed after the INSERT proper.

I'm confused.  DO INSTEAD doesn't mean DO INSTEAD?

> You could maybe make this work with a BEFORE INSERT trigger.

I'm not sure you can make it reliable though.

...Robert

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5079: postgres killed by signal 11 when executing xslt_process function from xml2 contrib module.
Next
From: Tom Lane
Date:
Subject: Re: BUG #5081: ON INSERT rule does not work correctly