X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9C43F475BA1 for ; Mon, 3 Feb 2003 10:41:32 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 672BB47592C for ; Mon, 3 Feb 2003 10:40:25 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h13FeT5u019252; Mon, 3 Feb 2003 10:40:29 -0500 (EST) To: "Rajesh Kumar Mallah." Cc: pgsql-sql@postgresql.org Subject: Re: cannot EXPLAIN query... In-reply-to: <200302032108.23554.mallah@trade-india.com> References: <200302031932.08326.mallah@trade-india.com> <14177.1044283565@sss.pgh.pa.us> <200302032108.23554.mallah@trade-india.com> Comments: In-reply-to "Rajesh Kumar Mallah." message dated "Mon, 03 Feb 2003 21:08:23 +0530" Date: Mon, 03 Feb 2003 10:40:29 -0500 Message-ID: <19251.1044286829@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/57 X-Sequence-Number: 11455 "Rajesh Kumar Mallah." writes: > It is PostgreSQL 7.3.0 on Linux. Try 7.3.1 then. I think this is this problem: 2002-12-06 14:28 tgl * src/backend/commands/explain.c (REL7_3_STABLE): Explain's code for showing quals of SubqueryScan nodes has been broken all along; not noticed till now. It's a scan not an upper qual ... regards, tom lane