Re: Questions of 'for update' - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Questions of 'for update'
Date
Msg-id CAPmGK17Xrj6iDuLTmBeKeMrSAbccvUr8doaaxnQoeXOWF4EkgQ@mail.gmail.com
Whole thread Raw
In response to Re: Questions of 'for update'  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
Responses Re: Questions of 'for update'
List pgsql-hackers
Hi,

On Mon, Jun 10, 2019 at 3:50 PM Kuntal Ghosh <kuntalghosh.2007@gmail.com> wrote:
> On Mon, Jun 10, 2019 at 11:31 AM Zhenghua Lyu <zlv@pivotal.io> wrote:
>> 2. Is the case above a bug or a feature?
>>
> IMHO, it looks like an expected behaviour of a correct transaction management implementation.

This is documented behavior; see the Caution for The Locking Clause on
the SELECT reference page:
https://www.postgresql.org/docs/11/sql-select.html

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: Kuntal Ghosh
Date:
Subject: Re: Questions of 'for update'
Next
From: Kuntal Ghosh
Date:
Subject: Re: Questions of 'for update'