Re: get user info on log

On 9/16/22 06:00, Marcos Pegoraro wrote:
> Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver 
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> escreveu:
> 
>     test(5432)=# set role maura;
>     ERROR:  role "maura" does not exist
>     test(5432)=# SET SESSION AUTHORIZATION 'maura';
>     ERROR:  role "maura" does not exist
> 
> No, I was asking about an error occurring later, not on set session 
> authorization command.
> 
> set role maura;
> --user Maura exists and set was done correctly
> --now I´m working as Maura
> select 1/0; -- I would like to see this exception on log being logged as 
> maura

I don't know of a way to get this.

> 
> thanks
> Marcos
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com