[GENERAL] Where is the pg_terminate_backend() function? Way to execute shell cmd

Hi, 1. On Postgresql 8.1.4, i can't use pg_terminate_backend(int) function. How can i use this function? 2. How can i execute a shell command? I need to terminate a client connection(some times active, some times idle one) by a query. I can undertake the risc for it. :) Regards, Mustafa Yoruk

Re: [GENERAL] Execute a function upon a connection made/closed

A. Kretschmer wrote, On 13.10.2006 12:32: am Fri, dem 13.10.2006, um 12:25:38 +0300 mailte Uyelik folgendes: Hi, Is there any way to execute a function upon a new connection made or existing one closed? IIRC no, but you can set variables, perhaps this will help you

[GENERAL] Execute a function upon a connection made/closed

Hi, Is there any way to execute a function upon a new connection made or existing one closed? Is active connections info stored on a table or (?) ? Regards, Mustafa

Re: [GENERAL] PL/SQL: function call like $1($2)

Hi, you may try; execute 'select ' || f || '(' || p || ')' into res; Merlin Moncure wrote, On 09.10.2006 16:35: On 10/8/06, Jean-Gerard Pailloncy <[EMAIL PROTECTED]> wrote: I want to create a function in PL/SQL as CREATE OR REPLACE FUNCTION "f_do" (text, double precision[]) RETURNS