Postgres Pro
Downloads
Home   >   mailing lists

Re: Row locking within a SELECT statement - Mailing list pgsql-docs

From Marko Tiikkaja
Subject Re: Row locking within a SELECT statement
Date
Msg-id c0e51a2d-b3a1-dc0f-9307-51c054a7a334@joh.to
Whole thread Raw
In response to Row locking within a SELECT statement  (xrg@linux.gr)
Responses Re: Row locking within a SELECT statement  ("P. Christeas" <xrg@linux.gr>)
List pgsql-docs
Tree view 
On 2016-08-16 08:19, xrg@linux.gr wrote:
> In order to avoid concurrent manipulation of rows, I do issue a "SELECT ..
> FOR UPDATE" 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

pgsql-docs by date:

Previous
From: Alexander Law
Date:
Subject: Outdated sentence in the pg_am description
Next
From: "P. Christeas"
Date:
Subject: Re: Row locking within a SELECT statement