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. ALTER name SET parameter { TO | = } { value | DEFAULT } > Is active connections info stored on a table or (?) ? In a system-view, pg_stat_activity. You can select from there. HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net