Daniel Grace <dgr...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
