"Rajesh Kumar Mallah." <mallah(at)trade-india(dot)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