Statement cancel or transaction cancel?

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Statement cancel or transaction cancel?
Date: 2005-03-11 09:07:13
Message-ID: d0rnch$1kf4$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Qingqing Zhou 2005-03-11 09:32:05 Re: IO Timeout
Previous Message Devrim GUNDUZ 2005-03-11 08:41:48 New PostgreSQL RPMs are available for many platforms