X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 99D464758DC
	for <pgsql-sql@postgresql.org>; Mon,  3 Feb 2003 09:10:55 -0500 (EST)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id EAE8C475A71
	for <pgsql-sql@postgresql.org>; Mon,  3 Feb 2003 09:10:53 -0500 (EST)
Received: from klaster.net (ph93.krakow.cvx.ppp.tpnet.pl [217.99.208.93])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 5EAF32B742; Mon,  3 Feb 2003 15:04:33 +0100 (CET)
Message-ID: <3E3E799B.1020707@klaster.net>
Date: Mon, 03 Feb 2003 15:15:55 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: "Rajesh Kumar Mallah." <mallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: cannot EXPLAIN query...
References: <200302031932.08326.mallah@trade-india.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/54
X-Sequence-Number: 11452

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