| From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | cannot EXPLAIN query... |
| Date: | 2003-02-03 14:02:08 |
| Message-ID: | 200302031932.08326.mallah@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Myrta | 2003-02-03 14:15:55 | Re: cannot EXPLAIN query... |
| Previous Message | Vicente Alabau Gonzalvo | 2003-02-03 12:45:55 | numeric when compared to literal |