> -----Original Message----- > From: Dan Langille [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 06, 2002 12:41 PM > To: Joel Burton > Cc: [EMAIL PROTECTED] > 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 | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org