Re: Row locking within a SELECT statement

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: xrg(at)linux(dot)gr, pgsql-docs(at)postgresql(dot)org
Subject: Re: Row locking within a SELECT statement
Date: 2016-08-16 09:23:59
Message-ID: c0e51a2d-b3a1-dc0f-9307-51c054a7a334@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 2016-08-16 08:19, xrg(at)linux(dot)gr wrote:
> In order to avoid concurrent manipulation of rows, I do issue a &quot;SELECT ..
> FOR UPDATE&quot; on the sets of rows, before UPDATEing them (because UPDATEs
> cannot be ordered).

Yeah, but FOR UPDATEs are not ordered either unless you use ORDER BY,
which you didn't.

.m

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message P. Christeas 2016-08-16 10:30:06 Re: Row locking within a SELECT statement
Previous Message Alexander Law 2016-08-16 07:33:09 Outdated sentence in the pg_am description