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

Daniel Grace <dgrace@wingsnw.com> writes:
> Plan that fails on EXPLAIN VERBOSE:
> "Nested Loop  (cost=0.00..132.35 rows=24 width=4)"
> "  ->  Subquery Scan on t  (cost=0.00..131.00 rows=6 width=4)"
> "        Filter: (t.foo IS NULL)"
> "        ->  WindowAgg  (cost=0.00..119.50 rows=1150 width=4)"
> "              ->  Merge Join  (cost=0.00..102.25 rows=1150 width=4)"
> "                    Merge Cond: (acal.id = acal.id)"
> "                    ->  Index Scan using allocation_calendar_pkey on
> allocation_calendar acal  (cost=0.00..42.50 rows=1150 width=4)"
> "                    ->  Index Scan using allocation_calendar_pkey on
> allocation_calendar acal  (cost=0.00..42.50 rows=1150 width=4)"
> "  ->  Materialize  (cost=0.00..1.06 rows=4 width=0)"
> "        ->  Seq Scan on yearinfo yi  (cost=0.00..1.04 rows=4 width=0)"
> --> ERROR:  invalid attnum 2 for rangetable entry t

I've applied a patch for this; it'll be in 9.0beta4.  Thanks for the
report!

            regards, tom lane