Re: cannot EXPLAIN query...

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah.
Тема Re: cannot EXPLAIN query...
Дата
Msg-id 200302032202.38296.mallah@trade-india.com
обсуждение исходный текст
Ответ на Re: cannot EXPLAIN query...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: cannot EXPLAIN query...  (<mallah@trade-india.com>)
Список 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 по дате отправления:

Предыдущее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: Re: cannot EXPLAIN query...
Следующее
От: Josef Astner
Дата:
Сообщение: unsubscribe