Horton

Re: Re: postgres TODO

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Alessio Bragadini <alessio@albourne.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, " XosÉ Vázquez " <xose@wanadoo.es>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2000-07-10T13:25:51Z
Lists: pgsql-hackers 
> Peter Eisentraut wrote:
> 
> > Bruce Momjian writes:
> > 
> > >       * Add function to return primary key value on INSERT
> > 
> > I don't get the point of this. Don't you know what you inserted? For
> > sequences there's curval()
> 
> Mmmhhh... it means that we can assume no update to the sequence value
> between the insert and the curval selection?

No curval() is per-backend value that is not affected by other users. 
My book has a mention of that issue, and so does the FAQ.

-- 
  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