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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
