On Fri, 9 Apr 2004, Ben Kim wrote: > > Dear admins, > > I have a table whose primary key is a record_id with serial type. > > I would like to know, when I insert a new row, what was the value of the > record_id that I just inserted. Since this is a multi user application, I > cannot simply select max of the record_id or currval of the sequence. > > I would appreciate an advice.
You want the functions for sequences: nextval, currval, and setval: http://www.postgresql.org/docs/7.4/static/functions-sequence.html nextval and currval are transactionally safe. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly