Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group