| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | salman <salmanb(at)quietcaresystems(dot)com> |
| Cc: | Scara Maccai <m_lists(at)yahoo(dot)it>, postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: TODO list and "hyphen" |
| Date: | 2008-07-18 02:22:52 |
| Message-ID: | 200807180222.m6I2Mqq19861@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2008-07-18 02:23:29 | Re: TODO list and "hyphen" |
| Previous Message | Francisco Reyes | 2008-07-18 01:21:13 | Reducing memory usage of insert into select operations? |