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.