Re: failed to fetch tuple for EvalPlanQual recheck - Mailing list pgsql-bugs

From Tom Lane
Subject Re: failed to fetch tuple for EvalPlanQual recheck
Date
Msg-id 18614.1280337804@sss.pgh.pa.us
Whole thread Raw
In response to failed to fetch tuple for EvalPlanQual recheck  (Kenichiro Tanaka <ketanaka@ashisuto.co.jp>)
Responses Re: failed to fetch tuple for EvalPlanQual recheck  (Kenichiro Tanaka <ketanaka@ashisuto.co.jp>)
List pgsql-bugs
Kenichiro Tanaka <ketanaka@ashisuto.co.jp> writes:
> 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

pgsql-bugs by date:

Previous
From:
Date:
Subject: Re: pg_upgrade issues
Next
From: "y.y.chen"
Date:
Subject: BUG #5576: Boolean operation should not be Complete boolean evaluation