> -----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. 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
