> On Tue, Oct 23, 2001 at 02:38:04PM -0400, Kevin HaleBoyes wrote:
> > Is this actually guaranteed to work?
> > What happens if another call to append_test() is made such that
> > the insert takes place in the first call, then the insert takes place
> > in the second call before the select currval().
>
> Yes, it's guarenteed to work. If you examine the documentation for
> currval(), you will get the last value returned by nextval() *in this
> session*. Whatever happens in other sessions is irrelevent.
>
> I think this needs to be highlighted more in the documentation since many
> people miss this very important point.
I have highlighted it more in the FAQ. Yes, many people miss that.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026