Rajesh Kumar Mallah. wrote:
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.
Isn't it a very long view? I found some limitations of explain, but possibly they
had something to cygwin enviroment.
Regards,
Tomasz Myrta
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly