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(dot)klaver(at)aklaver(dot)com