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

From Zeugswetter Andreas SB
Subject AW: Re: postgres TODO
Date
Msg-id 11C1E6749A55D411A9670001FA687963367FEB@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Re: postgres TODO  (The Hermit Hacker <scrappy@hub.org>)
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.

Not all default values need to be a sequence, thus imho
this function is a useful extension. ODBC has it too.

Andreas


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: [GENERAL] PostgreSQL vs. MySQL
Next
From: Karel Zak
Date:
Subject: memory: bug or feature