Skip site navigation (1) Skip section navigation (2)

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

From: bricklen <bricklen(at)gmail(dot)com>
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 23:03:48
Message-ID: AANLkTin+AcvujAm4h1Mf5FPh1p2HQHYvo4btjKsd4Q-T@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Tue, Jan 4, 2011 at 2:47 PM, Bryce Nesbitt <bryce2(at)obviously(dot)com> wrote:
> Michael Glaesemann wrote:
>> Likely you're looking for pg_terminate_backend().
>> Michael Glaesemann
>> grzm seespotcode net
>>
>
> Hmm, yes.  Though it seems to not be in the documentation, or, for that
> matter, the current code:

8.4+

In response to

pgsql-sql by date

Next:From: Gary StainburnDate: 2011-01-05 09:53:43
Subject: foreign key question
Previous:From: Bryce NesbittDate: 2011-01-04 22:47:41
Subject: Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group