Re: [GENERAL] Deadlock with single update statement?

Поиск
Список
Период
Сортировка
От Rob Nikander
Тема Re: [GENERAL] Deadlock with single update statement?
Дата
Msg-id 5F9A7A22-53BF-441A-B5AC-ADDB71B1A030@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Deadlock with single update statement?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] Deadlock with single update statement?
Список pgsql-general
> On Jun 10, 2017, at 10:34 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> […] but it'd be better to adjust the query to ensure a deterministic
> update order.

Thank you for the answer. Since `update` has no `order by` clause, I’m guessing there’s no way to do this with just the
`update`statement, and that I should use `select … order by … for update’ for this. 






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