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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
