Statement cancel or transaction cancel?

Qingqing Zhou · *nix forums Guru Wannabe Joined: 11 Mar 2005 Posts: 101

Pg8.0.1

backend> begin;
backend> create table a (i int);
backend> insert into a values(1);
1: i (typeid = 23, len = 4, typmod = -1, byval = t)
----
backend> select * from pg_class;
1: relname (typeid = 19, len = 64, typmod = -1, byval = f)
2: relnamespace (typeid = 26, len = 4, typmod = -1, byval =
t)
3: reltype (typeid = 26, len = 4, typmod = -1, byval = t)
4: relowner (typeid = 23, len = 4, typmod = -1, byval = t)

.... before the query is finished, press a ctrl_c here ...

ERROR: canceling query due to user request
backend> select * from a;
ERROR: current transaction is aborted, commands ignored until end of
transaction block
backend> commit;
backend> select * from a;
ERROR: relation "a" does not exist

So ctrl_c in a backend actually means cancel the whole transaction (instead
of statement)?

Thanks,
Qingqing

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Sean Davis · *nix forums Guru Wannabe Joined: 01 Mar 2005 Posts: 172

On Mar 11, 2005, at 4:07 AM, Qingqing Zhou wrote:

Google