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