X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 03A374758DC for ; Mon, 3 Feb 2003 12:34:12 -0500 (EST) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 1304D4758F1 for ; Mon, 3 Feb 2003 12:34:08 -0500 (EST) Received: (qmail 10149 invoked from network); 3 Feb 2003 17:30:57 -0000 Received: from ns1.trade-india.com (HELO www.trade-india.com) (66.234.10.14) by infocom-236-129-del.trade-india.com with SMTP; 3 Feb 2003 17:30:57 -0000 Received: (qmail 6959 invoked by uid 99); 3 Feb 2003 17:34:19 -0000 Received: from 219.65.233.83 (proxying for 219.65.233.83) (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Mon, 3 Feb 2003 23:04:19 +0530 (IST) Message-ID: <8600.219.65.233.83.1044293659.squirrel@mail.trade-india.com> Date: Mon, 3 Feb 2003 23:04:19 +0530 (IST) Subject: Re: cannot EXPLAIN query... From: To: In-Reply-To: <200302032202.38296.mallah@trade-india.com> References: <200302031932.08326.mallah@trade-india.com> <200302032119.17934.mallah@trade-india.com> <19324.1044287157@sss.pgh.pa.us> <200302032202.38296.mallah@trade-india.com> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: , X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/66 X-Sequence-Number: 11464 Hi , This is to confirm that the EXPLAIN problem does not occur anymore after successfully upgrading to 7.3.1 from 7.3.0 Thanks everyone. Regards Mallah. explain select * from shippers1 where city=3D'DELHI'; = QUERY = PLAN----------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= --------------------------------------------------- Nested Loop (cost=3D0.= 00..26461.22 rows=3D1 width=3D339) -> Subquery Scan b (cost=3D0.00..26448.53 rows=3D477 width=3D307) Filter: (city =3D 'DELHI'::character varying) -> Append (cost=3D0.00..26448.53 rows=3D477 width=3D307) -> Subquery Scan "*SELECT* 1" (cost=3D0.00..6739.42 rows= =3D249 width=3D307) -> Index Scan using eyp_listing_category_id, eyp_list= ing_category_id, eyp_listing_category_id, eyp_listing_category_id, eyp_= listing_category_id on eyp_listing (cost=3D0.00..6739.42 rows=3D249 width=3D= 307) Index Cond: ((category_id =3D 1142) OR (cate= gory_id =3D 1143) OR (category_id =3D 1145) OR (category_id =3D 1259)= OR (category_id =3D 1161)) Filter: ((amount > 0)= AND (status =3D 'a'::character varying) AND (email IS NOT NULL)) -> Subquery Scan "*= SELECT* 2" (cost=3D0.00..9288.33 rows=3D77 width=3D286) -> Seq Scan on iid_listing (cost=3D0.00..9288.33 row= s=3D77 width=3D286) Filter: (((category_id =3D 1142) OR (category_id= =3D 1143) OR (category_id =3D 1145) OR (category_id =3D 1259) OR (category= _id =3D 1161)) AND (amount > 0) AND (status =3D 'a'::character varying) AND (= email IS NOT NULL)) -> Subquery Scan "*SELECT* 3" (cost=3D1= 0413.26..10420.79 rows=3D151 width=3D248) -> Unique (cost=3D10413.26..10420.79 rows=3D151 widt= h=3D248) -> Sort (cost=3D10413.26..10417.02 rows=3D1506= width=3D248) Sort Key: branding_master.company_id -> Hash Join (cost=3D339.35..10333.74 ro= ws=3D1506 width=3D248) Hash Cond: ("outer".company_id =3D "= inner".company_id) -> Seq Scan on branding_master (co= st=3D0.00..7171.80 rows=3D32985 width=3D242) = Filter: ((old_company_id =3D 0) AND (stat= us =3D 'a'::character varying) AND (e= mail IS NOT NULL) AND (eyp_paid IS NULL) AND (iid_pa= id IS NULL)) -> Hash (cost=3D331.00= ..331.00 rows=3D3339 width=3D6) -> Seq Scan on branding_sp_ca= tegory=20 (cost=3D0.00..331.00 rows=3D33= 39 width=3D6) Filter: ((c= ategory_id =3D 1142) OR (category_id =3D 1143) OR (category_id = =3D 1145) OR (category_id =3D 1259) OR (category_id = =3D 1161)) -> Index Scan using approved_profiles_id_key on approved_prof= iles a (cost=3D0.00..5.30 rows=3D1 width=3D15) Index Cond: ((a.id =3D "outer".id) AND (a.source =3D= "outer".source)) (24 rows) tradein_clients=3D# > > > Hmmm... upgrade to 7.3.1 was not that smooth.. > after upgrade i could not run a single query.. > > tradein_clients=3D> SELECT * from hogs; > ERROR: current transaction is aborted, queries ignored until end of tran= saction block > tradein_clients=3D> > any other query seems to be giving the same ERROR. > > check the message below on psql start (7.3.1) with a 7.3.1 server. > > PS: i applied the heir patch though ... ;-) will try again without that. > > [postgres@ns3 postgres]$ psql -Upostgres -h66.234.10.12 tradein_clients > >>> ERROR: nodeRead: did not find '}' at end of plan node > > Welcome to psql 7.3.1, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > tradein_clients=3D> > > > > > regds > mallah. > > > On Monday 03 February 2003 09:15 pm, Tom Lane wrote: >> "Rajesh Kumar Mallah." writes: >> > I think if i do that i will hve to immediately upgrade >> > all the 7.3.0 clients in other machines to 7.3.1 rite? >> >> No. >> >> regards, tom lane > > -- > > > -------------------------------------------- > 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. > > > > ---------------------------(end of broadcast)--------------------------- = TIP 1: subscribe and > unsubscribe commands go to majordomo@postgresql.org ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/