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

From Heikki Linnakangas
Subject Re: BUG #9557: Row not visible after receiving notification
Date
Msg-id 5321B67A.1060507@vmware.com
Whole thread Raw
In response to Re: BUG #9557: Row not visible after receiving notification  (Marko Tiikkaja <marko@joh.to>)
Responses Re: BUG #9557: Row not visible after receiving notification  (Marko Tiikkaja <marko@joh.to>)
List pgsql-bugs
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?

- Heikki

pgsql-bugs by date:

Previous
From: majid@apsalar.com
Date:
Subject: 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 #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns