Re: BUG #9557: Row not visible after receiving notification - Mailing list pgsql-bugs

From Marko Tiikkaja
Subject Re: BUG #9557: Row not visible after receiving notification
Date
Msg-id 5321B8E0.9040601@joh.to
Whole thread Raw
In response to Re: BUG #9557: Row not visible after receiving notification  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: BUG #9557: Row not visible after receiving notification  (Marko Tiikkaja <marko@joh.to>)
List pgsql-bugs
On 3/13/14 2:45 PM, Heikki Linnakangas wrote:
> On 03/13/2014 03:26 PM, Marko Tiikkaja wrote:
>> On 3/13/14 1:55 PM, I wrote:
>>> This would explain it, as I don't see the notification code checking
>>> whether the transaction is still in PGPROC, just calling
>>> TransactionIdDidCommit().
>>
>> And as predicted, adding a call to TransactionIdIsInProgress() in
>> asyncQueueProcessPageEntries makes the problem go away.
>
> Good catch! Want to write that into a patch?

I can do it if it helps, but I figured that it's a one-line change,
perhaps four with a nice comment..


Regards,
Marko Tiikkaja

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns
Next
From: Tom Lane
Date:
Subject: Re: BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug?