cannot EXPLAIN query...

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah.
Тема cannot EXPLAIN query...
Дата
Msg-id 200302031932.08326.mallah@trade-india.com
обсуждение исходный текст
Ответы Re: cannot EXPLAIN query...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: Format in psql
Следующее
От: Tomasz Myrta
Дата:
Сообщение: Re: cannot EXPLAIN query...