Re: <IDLE> in transaction - safest way to kill

From: "William Temperley" <willtemperley(at)gmail(dot)com>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: <IDLE> in transaction - safest way to kill
Date: 2008-12-05 15:44:54
Message-ID: 439dc11e0812050744p14562eb8v9cdce9f9e7963ed1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>
>> Could anyone tell me what's the best thing to with idle
>> transactions
>> that are holding locks?

On Fri, Dec 5, 2008 at 2:25 PM, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> wrote:
>
> select pg_cancel_backend(<pid>);
>

Thanks. Sorry for the basic question.

Will

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2008-12-05 15:53:20 Re: Application Stack Builder - proxy error
Previous Message Lee Keel 2008-12-05 15:42:25 Application Stack Builder - proxy error