Re: SELECT FOR UPDATE returns zero rows - Mailing list pgsql-novice

From amul sul
Subject Re: SELECT FOR UPDATE returns zero rows
Date
Msg-id CAAJ_b96WC4JP75CApJhD1L1WtJ2ucB-xSXROvsvY=nYX8+qAEA@mail.gmail.com
Whole thread Raw
In response to Re: SELECT FOR UPDATE returns zero rows  (Dima Pavlov <imyfess@gmail.com>)
List pgsql-novice
On Mon, Sep 19, 2016 at 9:28 PM, Dima Pavlov <imyfess@gmail.com> wrote:
>
> Did u perform all 4 steps from my scenarion with 2 parallel transactions? If i didn't have enough permissions then i
guessI would not get right result when execute sql query from the second transaction separately. 
>
Ohh I see, understood.

If simple query executed instead of CTE works as expected, looks like
a bug in CTE code.

Lets wait for other responses.
In case of no response in couple of days, we might need to write to
-hackers about this discovery. Thanks.

Regards,
Amul.


pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Permissions
Next
From: Tom C
Date:
Subject: JSON, JSONB questions