From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: cannot EXPLAIN query...
Date: Mon, 3 Feb 2003 22:02:38 +0530
Message-ID: <200302032202.38296.mallah@trade-india.com> (raw)
In-Reply-To: <19324.1044287157@sss.pgh.pa.us>
References: <200302031932.08326.mallah@trade-india.com>
<200302032119.17934.mallah@trade-india.com>
<19324.1044287157@sss.pgh.pa.us>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, tgl@sss.pgh.pa.us
Subject: Re: cannot EXPLAIN query...
In-Reply-To: <200302032202.38296.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox