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

From Rajesh Kumar Mallah.
Subject cannot EXPLAIN query...
Date
Msg-id 200302031932.08326.mallah@trade-india.com
Whole thread Raw
Responses Re: cannot EXPLAIN query...
List pgsql-sql
Hi,

the query is running  fine but i cannot EXPLAIN or (ANALYZE)
it.

I am seeing this message for the first time:


tradein_clients=# SELECT count(*) from shippers1 where city='DELHI';
+-------+
| count |
+-------+
|     2 |
+-------+
(1 row)

tradein_clients=#
tradein_clients=# explain  SELECT count(*) from shippers1 where city='DELHI';
ERROR:  get_names_for_var: bogus varno 5
tradein_clients=#

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


regds
MAllah.



Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)26152172 (221) (L) 9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.




pgsql-sql by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Format in psql
Next
From: Tomasz Myrta
Date:
Subject: Re: cannot EXPLAIN query...