Hi, On Mon, Jun 10, 2019 at 3:50 PM Kuntal Ghosh <kuntalghosh.2...@gmail.com> wrote: > On Mon, Jun 10, 2019 at 11:31 AM Zhenghua Lyu <z...@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