On 10-11-2011 21:12, Tomas Vondra wrote: > I occasionally need to perform some action whenever a user connects, and > there's nothing like an "AFTER LOGON" trigger (available in some other > databases). > Are you proposing an on-logon hook or an on-connect trigger? It is two separate things. The former can't solve some tasks (e.g. execute whatever pl code) and the latter can't be implemented with a simple hook (you will have to propose a syntax and offer some machinery to execute the pl code).
Of course, if you want to propose any of these ideas, keep in mind that a symmetric functionality (e.g. on-logoff hook or on-disconnect trigger) should be implemented too. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers