Re: failed to fetch tuple for EvalPlanQual recheck

From: Kenichiro Tanaka <ketanaka(at)ashisuto(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: failed to fetch tuple for EvalPlanQual recheck
Date: 2010-08-02 07:32:34
Message-ID: 4C567492.9040103@ashisuto.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.

I tried the test in PostgreSQL9.0 beta4.
And it never reproduces the EvalPlanQual recheck error!

Thank you for all reply!!

>> When I tested in PostgreSQL9 beta3,I got an error.
>>
>
>> ==================================================
>> select * from part_bug where HIRENUM=4 for update;
>> failed to fetch tuple for EvalPlanQual recheck
>> ==================================================
>>
> This seems to be a simple oversight in the new EvalPlanQual logic ---
> one place forgot to consider the possibility of inactive child tables.
> I've committed a patch. Thanks for the report!
>
> regards, tom lane
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Divyaprakash 2010-08-02 14:20:33 BUG #5591: Creating and using databases
Previous Message John Regehr 2010-08-02 06:07:21 BUG #5590: undefined shift behavior