Re: Serialization, Locking...implement processing Queue with a table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Serialization, Locking...implement processing Queue with a table
Дата
Msg-id 23782.1052922831@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Serialization, Locking...implement processing Queue with a table  ("D. Dante Lorenso" <dante@lorenso.com>)
Список pgsql-general
Дерево обсуждения 
"D. Dante Lorenso" <dante@lorenso.com> writes:
> You can't do it this way because if this select IS successful,
> you'll still need to LOCK the row for the update.

That's why you should be using SELECT FOR UPDATE.

            regards, tom lane

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