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

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Bryce Nesbitt <bryce2(at)obviously(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug?
Date: 2011-01-04 22:32:43
Message-ID: 6EEECA52-4293-405D-8124-A04A02D40F3E@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 that backend.

Likely you're looking for pg_terminate_backend().

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2011-01-04 22:47:41 Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug?
Previous Message Bryce Nesbitt 2011-01-04 22:29:37 "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug?