Re: Killing process through of a function - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Killing process through of a function
Date
Msg-id 20050218181540.GA79521@winnie.fuhr.org
Whole thread Raw
In response to Re: Killing process through of a function  ("alexandre::aldeia digital" <alepaes@aldeiadigital.com.br>)
List pgsql-general
On Fri, Feb 18, 2005 at 10:05:25AM -0200, alexandre::aldeia digital wrote:

> IBM DB2 have functions that allow the DBA to disconnect some clients.
> This is very usefull for database maintenance without giving a shell to him.

As I mentioned, you could write a function in C, PL/Perl, etc.,
that sends a signal to a client's backend process, but I think
there's concern about how robust that is, which is why it hasn't
become a standard function.  See the following message and the
messages it references:

http://archives.postgresql.org/pgsql-general/2005-02/msg00426.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL Replication
Next
From: Tom Lane
Date:
Subject: Re: PGSQL 8.0.1 Win 2K Installation Problem