Re: cannot EXPLAIN query... - Mailing list pgsql-sql

From Rajesh Kumar Mallah.
Subject Re: cannot EXPLAIN query...
Date
Msg-id 200302032202.38296.mallah@trade-india.com
Whole thread Raw
In response to Re: cannot EXPLAIN query...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: cannot EXPLAIN query...  (<mallah@trade-india.com>)
List pgsql-sql

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." <mallah@trade-india.com> 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.




pgsql-sql by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: cannot EXPLAIN query...
Next
From: Josef Astner
Date:
Subject: unsubscribe