misleading message..

Hi ,

Within a transaction in thru psql if we cancel
a given query with ^C then the transaction is
not commited.

what is disturbing is the COMMIT does not even gives
an warning or error.

the transaction is silently rollbacked.

regd
mallah.


tradein_clients=# begin work;UPDATE  eyp_listing set keywords=category  where amount > 0 and keywords is null ;
BEGIN
Time: 870.45 ms
UPDATE 6022
Time: 175940.80 ms
tradein_clients=# SELECT keywords,size,category from eyp_listing where amount > 0 and keywords is null limit 20;

^C
Cancel request sent
ERROR:  Query was cancelled.
tradein_clients=# COMMIT ;
COMMIT
Time: 1015.37 ms
tradein_clients=#
tradein_clients=#
tradein_clients=#


ERROR:  current transaction is aborted, queries ignored until end of transaction block


Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.