Re: [GENERAL] Deadlock with single update statement? - Mailing list pgsql-general

From Rob Nikander
Subject Re: [GENERAL] Deadlock with single update statement?
Date
Msg-id 5F9A7A22-53BF-441A-B5AC-ADDB71B1A030@gmail.com
Whole thread Raw
In response to Re: [GENERAL] Deadlock with single update statement?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] Deadlock with single update statement?
List 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 by date:

Previous
From: Steven Grimm
Date:
Subject: Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Deadlock with single update statement?