Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN
Date
Msg-id 19090.1278698655@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN  (Daniel Grace <dgrace@wingsnw.com>)
List pgsql-bugs
Daniel Grace <dgrace@wingsnw.com> writes:
> So I've spent the greater portion of the last two hours trying to slim
> down the schema and query enough to provide something that can
> reproduce this.

> While I can reproduce it 100% of the time with live data, I can't get
> it to reproduce at all with test data -- though I've included a few
> schemas below.  It seems to be based on what plan ends up being
> constructed for the query.

Maybe you could force it for the test data with some suitable
combination of the enable_plantype switches.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Daniel Grace
Date:
Subject: Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN
Next
From: Robert Haas
Date:
Subject: Re: BUG #5539: Generally incorrect planner estimations on join with UNION ALL