Getting value of SERIAL column after insert from libpq?

Поиск

Список

Период

Сортировка

От	Mark Alliban
Тема	Getting value of SERIAL column after insert from libpq?
Дата	20 декабря 1999 г. 09:26:58
Msg-id	003401bf4af5$0f3b4a10$c80110ac@centauri обсуждение исходный текст
Ответы	Re: [GENERAL] Getting value of SERIAL column after insert from libpq?
Список	pgsql-general

Дерево обсуждения

Hi,

I have written a C program to insert a row into a table with a SERIAL column.

Is there a way of returning the inserted value for this column to my program? I.e. if there are rows with the serial column for 1,2,3,4 and 5, and I insert a row, my program needs to be told "6" for the new serial. There may be many instances of the program running simultaneously so I can't do a "select max..." or "select last_value..." workaround because by the time the select is done, there may have been other rows inserted so the last_value would be wrong. Also the program needs to be table-name and column-name independent so that it can work for ANY insert query into a table with a SERIAL column.

TIA,

Mark.

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Getting value of SERIAL column after insert from libpq?