Re: Deadlock with single update statement?

From: Rob Nikander <rob(dot)nikander(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Deadlock with single update statement?
Date: 2017-06-10 19:11:31
Message-ID: 5F9A7A22-53BF-441A-B5AC-ADDB71B1A030@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Jun 10, 2017, at 10:34 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-06-10 19:16:26 Re: Deadlock with single update statement?
Previous Message Steven Grimm 2017-06-10 16:17:32 Re: Inconsistent performance with LIKE and bind variable on long-lived connection