Re: Atomic/locked "allocation" of table row?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Atomic/locked "allocation" of table row?
Дата
Msg-id 27701.1186413563@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Atomic/locked "allocation" of table row?  (Sten Daniel Soersdal <netslists@gmail.com>)
Список pgsql-novice
Sten Daniel Soersdal <netslists@gmail.com> writes:
> According to the manual it says that this would sometimes fail when
> "serializable" isolation cannot be obtained, is there any way to make it
> wait for it? Or do i have to wrap the transaction with an exception clause?

If you don't want it to fail on conflicts, don't use SERIALIZABLE.
Instead, use SELECT FOR UPDATE followed by UPDATE within a transaction.

            regards, tom lane

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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: doubt about datum
Следующее
От: Tom Lane
Дата:
Сообщение: Re: doubt about datum