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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
