Re: get user info on log - Mailing list pgsql-general

From Adrian Klaver
Subject Re: get user info on log
Date
Msg-id 227d9194-c48d-d244-e7c5-beb433dec212@aklaver.com
Whole thread Raw
In response to Re: get user info on log  (Marcos Pegoraro <marcos@f10.com.br>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: get user info on log
Next
From: Avi Weinberg
Date:
Subject: Logical Replication - Give One Subscription Priority Over Other Subscriptions