Re: select locks table for updates

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Michel SALAIS <msalais(at)msym(dot)fr>
Cc: Yambu <hyambu(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: select locks table for updates
Date: 2020-11-19 21:13:30
Message-ID: CANP8+j+OWE7+HtegL=N+gxPLdifRDYoveUuX2qYyDYUgD9hdPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 19 Nov 2020 at 10:20, Michel SALAIS <msalais(at)msym(dot)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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2020-11-19 21:14:17 Re: Logical replication
Previous Message Holger Jakobs 2020-11-19 20:46:19 Re: Logical replication