Re: get user info on log

On 9/13/22 12:45, Marcos Pegoraro wrote:
> When using set role or set session authorization and an error occurs I 
> get user name which logged in and not the one I´ve changed to.
> 
> There is a way to get session_user and current_user on log ?

When I do:

test(5432)=# set role maura;
ERROR:  role "maura" does not exist
test(5432)=# SET SESSION AUTHORIZATION 'maura';
ERROR:  role "maura" does not exist


I get:

psql-postgres-2022-09-15 08:53:41.204 PDT-0ERROR:  role "maura" does not 
exist
psql-postgres-2022-09-15 08:53:41.204 PDT-0STATEMENT:  set role maura;
psql-postgres-2022-09-15 08:55:26.325 PDT-0ERROR:  role "maura" does not 
exist
psql-postgres-2022-09-15 08:55:26.325 PDT-0STATEMENT:  SET SESSION 
AUTHORIZATION 'maura';

in the logs.

Are you not seeing that or do you want something different?

If you want something different then you will need to provide a more 
detailed description of what that is.

> 
> Thanks
> Marcos


-- 
Adrian Klaver
adrian.klaver@aklaver.com