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.