Re: [HACKERS] EXPLAIN with view: bogus varno: 5

2005-08-27 Thread Oleg Bartunov
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

Re: [HACKERS] EXPLAIN with view: bogus varno: 5

2005-08-27 Thread Tom Lane
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. regards,

[HACKERS] EXPLAIN with view: bogus varno: 5

2005-08-26 Thread Michael Fuhr
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