Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 590141337B53
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Jan 2011 18:58:46 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 47486-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  4 Jan 2011 22:58:40 +0000 (UTC)
X-Greylist: delayed 00:25:46.543562 by SQLgrey-1.7.6
Received: from proton.planetargon.com (proton.planetargon.com
 [198.145.115.11])
	by mail.postgresql.org (Postfix) with ESMTP id 369641337B39
	for <pgsql-sql@postgresql.org>; Tue,  4 Jan 2011 18:58:38 -0400 (AST)
Received: by proton.planetargon.com (Postfix, from userid 502)
	id 30C1B82DDD9; Tue,  4 Jan 2011 14:32:51 -0800 (PST)
Received: from [192.168.2.23] (unknown [68.64.144.221])
	by proton.planetargon.com (Postfix) with ESMTP id 98A5982DDD3;
	Tue,  4 Jan 2011 14:32:45 -0800 (PST)
Subject: Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend().
	Is it a bug?
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: text/plain; charset=us-ascii
From: Michael Glaesemann <grzm@seespotcode.net>
In-Reply-To: <4D239F51.2000102@obviously.com>
Date: Tue, 4 Jan 2011 17:32:43 -0500
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <6EEECA52-4293-405D-8124-A04A02D40F3E@seespotcode.net>
References: <4D239F51.2000102@obviously.com>
To: Bryce Nesbitt <bryce2@obviously.com>
X-Mailer: Apple Mail (2.1082)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201101/3
X-Sequence-Number: 34950


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