Re: Best approach for a "gap-less" sequence

Поиск
Список
Период
Сортировка
От AgentM
Тема Re: Best approach for a "gap-less" sequence
Дата
Msg-id F4725942-60DF-4C06-A1F4-E9FC313CDDBF@themactionfaction.com
обсуждение исходный текст
Ответ на Re: Best approach for a "gap-less" sequence  (Jorge Godoy <jgodoy@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Just in case no one else has brought it up- 8.1+ supports 2PC and
savepoints, so one alternative would be to run your standard
insertion operations in a prepared transaction or savepoint block. If
you get so far as being able to prepare the transaction/complete the
savepoint block, you should be able to snag a sequence id and commit
everything.

-M

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

Предыдущее
От: Kevin Murphy
Дата:
Сообщение: Re: COLLATE
Следующее
От: "Harald Armin Massa"
Дата:
Сообщение: PostgreSQL getting slower over time, restart of service cures the problem