Statement cancel or transaction cancel?

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Statement cancel or transaction cancel?
Дата
Msg-id d0rnch$1kf4$1@news.hub.org
обсуждение исходный текст
Ответы Re: Statement cancel or transaction cancel?  (Sean Davis <sdavis2@mail.nih.gov>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: New PostgreSQL RPMs are available for many platforms
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: partitionning