Michael Fuhr <[EMAIL PROTECTED]> writes:
> Running EXPLAIN on a view that has an aggregate and uses an index
> results in the error "bogus varno: 5".
I've committed a fix for this --- it was a bug in the recently added
code that eliminates useless SubqueryScan nodes.
regar
I'm not sure it's relevant to Michaels' case, but I see message (8.1dev)
ERROR: bogus varno: 2
tp=# explain select name_qualified from place, to_tsquery('moscow') as query
where fts_index @@ query;
ERROR: bogus varno: 2
In my case, this select produces core dump while being rewritten works
Running EXPLAIN on a view that has an aggregate and uses an index
results in the error "bogus varno: 5". At least I think the aggregate
and index are necessary -- removing either from the following example
allows EXPLAIN to succeed:
test=> CREATE TABLE foo (x integer);
CREATE TABLE
test=> CREATE