Postgres Pro
Downloads
Home   >   mailing lists

Re: select locks table for updates - Mailing list pgsql-admin

From Simon Riggs
Subject Re: select locks table for updates
Date
Msg-id CANP8+j+OWE7+HtegL=N+gxPLdifRDYoveUuX2qYyDYUgD9hdPQ@mail.gmail.com
Whole thread Raw
In response to RE: select locks table for updates  ("Michel SALAIS" <msalais@msym.fr>)
Responses RE: select locks table for updates  ("Michel SALAIS" <msalais@msym.fr>)
List pgsql-admin
Tree view 
On Thu, 19 Nov 2020 at 10:20, Michel SALAIS <msalais@msym.fr> wrote:
>
> No! Not in PostgreSQL.

In normal SELECTs, that is correct.

If you use SELECT ... FOR UPDATE then rows will be locked.

-- 
Simon Riggs                http://www.EnterpriseDB.com/

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Logical replication
Next
From: Yambu
Date:
Subject: Re: Logical replication