Re: cannot EXPLAIN query... - Mailing list pgsql-sql

"Rajesh Kumar Mallah." <mallah@trade-india.com> writes:
> tradein_clients=# explain  SELECT count(*) from shippers1 where city='DELHI';
> ERROR:  get_names_for_var: bogus varno 5

What version is this?  ISTR having fixed some bugs that might cause that.

> i can paste the nasty view definations if nothing is obvious till
> now.

If it's a current release, we need to see *all* the schema definitions
referenced by the query --- views and tables.
        regards, tom lane