> -----Original Message----- > From: Joel Burton [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 06, 2002 10:51 AM > To: Rajesh Kumar Mallah.; Gaetano Mendola; [EMAIL PROTECTED] > Subject: RE: [ADMIN] SERIAL Field > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Rajesh Kumar > > Mallah. > > Sent: Monday, May 06, 2002 9:26 AM > > To: Gaetano Mendola; [EMAIL PROTECTED] > > Subject: Re: [ADMIN] SERIAL Field > > > But the very idea of inserting the value and then retriving the > sequence > > number sounds fishy to me. Why not get the sequence number > first and than > > insert using that seqnce number (more on the flash tutorial ). > > Hmmm... does nextval() 'hold' a sequence number for this backend? > Otherwise, the risk would be that you request a value, and > someone else has beat you to it before you insert it.
Duh. Of course it does. Forgive me: it's still a bit early here in EST for my brain to be on. > 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. > > J. > > Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton > Knowledge Management & Technology Consultant ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
