Re: SELECT FOR UPDATE returns zero rows

From: amul sul <sulamul(at)gmail(dot)com>
To: Dima Pavlov <imyfess(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SELECT FOR UPDATE returns zero rows
Date: 2016-09-21 09:10:29
Message-ID: CAAJ_b96WC4JP75CApJhD1L1WtJ2ucB-xSXROvsvY=nYX8+qAEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Sep 19, 2016 at 9:28 PM, Dima Pavlov <imyfess(at)gmail(dot)com> wrote:
>
> Did u perform all 4 steps from my scenarion with 2 parallel transactions? If i didn't have enough permissions then i guess I 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom C 2016-09-29 02:07:52 JSON, JSONB questions
Previous Message David G. Johnston 2016-09-20 23:09:57 Re: Permissions