On Thu, Jul 20, 2017 at 8:47 AM, Yugo Nagata <nag...@sraoss.co.jp> wrote: > > Hi, > > Currently, PostgreSQL doen't have a hook triggered at session > start. Although we already have ClientAuthentication_hook, > this is triggered during authentication, so we can not > access the database. > > If we have a hook triggerd only once at session start, we may > do something useful on the session for certain database or user. > > For example, one of our clients wanted such feature. He wanted > to handle encription for specific users, though I don't know > the detail. > > The attached patch (session_start_hook.patch) implements such > hook. > > Another patch, session_start_sample.patch, is a very simple > example of this hook that changes work_mem values for sessions > of a specific database. > > I would appreciate hearing your opinion on this hook. >
I'm not sure your real needs but doesn't it material for improve Event Triggers??? Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog: http://fabriziomello.github.io >> Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello >> Github: http://github.com/fabriziomello