sequence value of the record just inserted.

Поиск
Список
Период
Сортировка
От Ben Kim
Тема sequence value of the record just inserted.
Дата
Msg-id Pine.GSO.4.10.10404090954300.10715-100000@edsun.coe.tamu.edu
обсуждение исходный текст
Ответы Re: sequence value of the record just inserted.  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: sequence value of the record just inserted.  (jseymour@LinxNet.com (Jim Seymour))
Список pgsql-admin
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.

Regards,
Ben Kim


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Trouble restoring 7.2.1 database into 7.4.2 database
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Multiple disks