> -----Original Message-----
> From: Dan Langille [mailto:dan(at)langille(dot)org]
> Sent: Monday, May 06, 2002 12:41 PM
> To: Joel Burton
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] SERIAL Field
>
> > In any event, inserting then using currval() is the standard practice
> > around here, and it works great. Nothing fishy at all here,
> nothing to see,
> > move on.
>
> Why is that "less risk"?
It's not; nextval() is just fine. I was half asleep and thinking, I think,
of another database when I wrote that.
"You say nextval() + write, I say write + currval()..."
J.
Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant