Dmitry Yemanov wrote:

>
> Could you explain why? If the cache says "committed" or "dead", this means
> that the concurrent transaction has finished and we have an up-to-date info.
> If the cache says "active", we don't rely on this answer and try to get a
> lock to check whether it's actually true or not. If the lock failed - the
> transaction is still active. If the lock aquired - the transaction has
> finished, let's refetch TIP. Where is a failure in this logic?

That sounds good to me. So I guess the next step is to get the user's
test case and walk through it to figure out why he's not seeing the records.

Regards

Ann