Re: BUG #5081: ON INSERT rule does not work correctly

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