Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Grace <dgrace(at)wingsnw(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN
Date: 2010-07-09 18:04:15
Message-ID: 19090.1278698655@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Daniel Grace <dgrace(at)wingsnw(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-07-09 19:49:58 Re: BUG #5539: Generally incorrect planner estimations on join with UNION ALL
Previous Message Daniel Grace 2010-07-09 17:56:13 Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN