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:
nextval and currval are transactionally safe.
In response to
pgsql-admin by date
|Next:||From: CHRIS HOOVER||Date: 2004-04-09 17:30:00|
|Subject: Performance hit for turning on collectors?|
|Previous:||From: Tom Lane||Date: 2004-04-09 16:33:02|
|Subject: Re: Multiple disks |