Re: BUG #14328: SELECT FOR UPDATE doesn't return existing row

From: Andomar <andomar(at)aule(dot)net>
To: imyfess(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14328: SELECT FOR UPDATE doesn't return existing row
Date: 2016-09-19 16:18:49
Message-ID: FEDF49DE-8374-4776-A55A-64D3FE50669B@aule.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I can reproduce this on 9.4 on Debian Linux.

This relates to a question on Stack Overflow: http://stackoverflow.com/q/39550510/50552

The row seems to be dropped from the result set after the query waits on the lock.

Cheers,
Andomar

> On 19 Sep 2016, at 18:01, imyfess(at)gmail(dot)com wrote:
>
> 14328

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2016-09-19 18:53:24 Re: BUG #14319: Logical decoding dropping statements in subtransactions
Previous Message imyfess 2016-09-19 16:01:36 BUG #14328: SELECT FOR UPDATE doesn't return existing row