Re: Trigger function always logs postgres as user name

2019-02-15 Thread Alexander Reichstadt
HI, The answer to the question is that you need to use session_user instead of user or current_user. Cheers, Alex > On 9 Feb 2019, at 10:08, Alexander Reichstadt wrote: > > Hi, > > I setup trigger functions for logging, and while they do work and get > triggered, the current_user always in

Re: Trigger function always logs postgres as user name

2019-02-09 Thread Francisco Olarte
Alexander: On Sat, Feb 9, 2019 at 1:32 PM Alexander Reichstadt wrote: > I setup trigger functions for logging, and while they do work and get > triggered, the current_user always insert “postgres” even when > updates/deletes/inserts are caused by users of another name. > How do I get it to use