Re: Re: postgres TODO - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Re: postgres TODO
Date
Msg-id 200007101325.JAA26878@candle.pha.pa.us
Whole thread Raw
In response to Re: Re: postgres TODO  (Alessio Bragadini <alessio@albourne.com>)
List 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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: postmaster errors with index on temp table?
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: more corruption