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.