Re: [HACKERS] proposal : backend startup hook / after logon trigger

2011-11-26 Thread Tomas Vondra
Dne 25.11.2011 17:48, Tom Lane napsal(a): > "Tomas Vondra" writes: >> On 25 Listopad 2011, 2:44, Robert Haas wrote: >>> I've thought of this before, but I'm not exactly clear on what the use >>> cases are. > >> The startup hook is useful for initializing an extension written in C, >> when the ext

Re: [HACKERS] proposal : backend startup hook / after logon trigger

2011-11-25 Thread Tom Lane
"Tomas Vondra" writes: > On 25 Listopad 2011, 2:44, Robert Haas wrote: >> I've thought of this before, but I'm not exactly clear on what the use >> cases are. > The startup hook is useful for initializing an extension written in C, > when the extension was loaded from postgresql.conf. If you need

Re: [HACKERS] proposal : backend startup hook / after logon trigger

2011-11-25 Thread Tomas Vondra
On 25 Listopad 2011, 2:44, Robert Haas wrote: > 2011/11/10 Tomas Vondra : >> Is there any particular reason why there's not a "backend start hook", >> executed right after a backend is initialized? I've tried a very simple >> PoC (basically just a new hook definition, called from PostgresMain(), >>

Re: [HACKERS] proposal : backend startup hook / after logon trigger

2011-11-24 Thread Robert Haas
2011/11/10 Tomas Vondra : > Is there any particular reason why there's not a "backend start hook", > executed right after a backend is initialized? I've tried a very simple > PoC (basically just a new hook definition, called from PostgresMain(), > see the after-logon-hook.diff (and a simple module

Re: [HACKERS] proposal : backend startup hook / after logon trigger

2011-11-10 Thread Tomas Vondra
On 11 Listopad 2011, 3:23, Euler Taveira de Oliveira wrote: > 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-lo

Re: [HACKERS] proposal : backend startup hook / after logon trigger

2011-11-10 Thread Euler Taveira de Oliveira
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 f

[HACKERS] proposal : backend startup hook / after logon trigger

2011-11-10 Thread Tomas Vondra
Hi, 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). Is there any particular reason why there's not a "backend start hook", executed right after a backend is initialized? I've tried a very s