Re: " in transaction" can't be killed with pg_cancel_backend(). Is it a bug?

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: " in transaction" can't be killed with pg_cancel_backend(). Is it a bug?
Дата
Msg-id 6EEECA52-4293-405D-8124-A04A02D40F3E@seespotcode.net
обсуждение исходный текст
Ответ на " in transaction" can't be killed with pg_cancel_backend(). Is it a bug?  (Bryce Nesbitt <bryce2@obviously.com>)
Список pgsql-sql
Дерево обсуждения 
On Jan 4, 2011, at 17:29, Bryce Nesbitt wrote:

> Should I expect pg_cancel_backend() to work in a case like this?  If not does this sound like a reportable bug?

pg_cancel_backend() cancels the running query for that backend. In the case of <IDLE>, there is no running query for
thatbackend. 

Likely you're looking for pg_terminate_backend().

Michael Glaesemann
grzm seespotcode net

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

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Re: " in transaction" can't be killed with pg_cancel_backend(). Is it a bug?
Следующее
От: bricklen
Дата:
Сообщение: Re: " in transaction" can't be killed with pg_cancel_backend(). Is it a bug?