Re: TODO list and "hyphen" - Mailing list pgsql-general

From Bruce Momjian
Subject Re: TODO list and "hyphen"
Date
Msg-id 200807180222.m6I2Mqq19861@momjian.us
Whole thread Raw
In response to Re: TODO list and "hyphen"  (salman <salmanb@quietcaresystems.com>)
List pgsql-general
salman wrote:
>  >> -Allow administrators to safely terminate individual sessions either
>   via an SQL function or SIGTERM  <<
>
> Can't you already do this with pg_cancel_backend() or kill <child pid>?

Cancel backend only cancels the current query but later queries are
still executed.  Kill was never officially supported as a way to
terminate a backend, but it will be in 8.4 and there is an SQL function
to do it too.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Reducing memory usage of insert into select operations?
Next
From: Bruce Momjian
Date:
Subject: Re: TODO list and "hyphen"