Re: lastval() - Mailing list pgsql-patches

From Tom Lane
Subject Re: lastval()
Date
Msg-id 501.1115789296@sss.pgh.pa.us
Whole thread Raw
In response to Re: lastval()  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Abhijit Menon-Sen wrote:
>> By the way, what would lastval() do if an insert trigger inserts a row
>> into a table with another serial column?

> It fails, just like it would fail now if the trigger inserted into the
> same table that used the trigger, or a rule.

If it actually *failed* that would be one thing, but the proposed
patch does not do that.  It looks more like the philosophy we usually
denigrate MySQL for, viz never fail even if you are staring a certain
application bug in the face.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: refactor index build
Next
From: Tom Lane
Date:
Subject: Re: lastval()