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='DELHI';
QUERY
PLAN-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=0.00..26461.22 rows=1 width=339)
-> Subquery Scan b (cost=0.00..26448.53 rows=477 width=307)
Filter: (city = 'DELHI'::character varying)
-> Append (cost=0.00..26448.53 rows=477 width=307)
-> Subquery Scan "*SELECT* 1" (cost=0.00..6739.42 rows=249 width=307)
-> Index Scan using eyp_listing_category_id,
eyp_listing_category_id,
eyp_listing_category_id, eyp_listing_category_id,
eyp_listing_category_id on
eyp_listing (cost=0.00..6739.42 rows=249 width=307)
Index Cond: ((category_id = 1142) OR (category_id = 1143) OR
(category_id = 1145) OR (category_id = 1259) OR
(category_id = 1161)) Filter: ((amount > 0) AND (status =
'a'::character varying) AND (email
IS NOT NULL)) -> Subquery Scan "*SELECT* 2"
(cost=0.00..9288.33 rows=77 width=286)
-> Seq Scan on iid_listing (cost=0.00..9288.33 rows=77
width=286)
Filter: (((category_id = 1142) OR (category_id = 1143) OR
(category_id
= 1145) OR (category_id = 1259) OR (category_id = 1161))
AND (amount >
0) AND (status = 'a'::character varying) AND (email IS NOT
NULL)) -> Subquery Scan "*SELECT* 3" (cost=10413.26..10420.79 rows=151
width=248)
-> Unique (cost=10413.26..10420.79 rows=151 width=248)
-> Sort (cost=10413.26..10417.02 rows=1506 width=248)
Sort Key: branding_master.company_id
-> Hash Join (cost=339.35..10333.74 rows=1506
width=248)
Hash Cond: ("outer".company_id =
"inner".company_id)
-> Seq Scan on branding_master
(cost=0.00..7171.80
rows=32985 width=242)
Filter: ((old_company_id = 0) AND (status =
'a'::character varying) AND (email IS NOT
NULL) AND
(eyp_paid IS NULL) AND (iid_paid IS
NULL)) -> Hash (cost=331.00..331.00 rows=3339
width=6)
-> Seq Scan on branding_sp_category
(cost=0.00..331.00 rows=3339 width=6)
Filter: ((category_id = 1142) OR
(category_id =
1143) OR (category_id = 1145) OR
(category_id =
1259) OR (category_id = 1161)) ->
Index Scan using approved_profiles_id_key on approved_profiles a (cost=0.00..5.30
rows=1
width=15) Index Cond: ((a.id = "outer".id) AND (a.source = "outer".source))
(24 rows)
tradein_clients=#
>
>
> Hmmm... upgrade to 7.3.1 was not that smooth..
> after upgrade i could not run a single query..
>
> tradein_clients=> SELECT * from hogs;
> ERROR: current transaction is aborted, queries ignored until end of transaction
>block
> tradein_clients=>
> 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=>
>
>
>
>
> regds
> mallah.
>
>
> On Monday 03 February 2003 09:15 pm, Tom Lane wrote:
>> "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
