Re: cannot EXPLAIN query...

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: cannot EXPLAIN query...
Date: 2003-02-03 16:32:38
Message-ID: 200302032202.38296.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)trade-india(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josef Astner 2003-02-03 16:40:11 unsubscribe
Previous Message Rajesh Kumar Mallah. 2003-02-03 15:59:03 Re: cannot EXPLAIN query...