get user info on log

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: get user info on log
Date: 2022-09-13 19:45:25
Message-ID: CAB-JLwYR8EQFepAuvBm2MPG9oWh1xXUR_deXguQYu4ijJNgAdg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks
Marcos

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-09-13 19:46:23 Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?
Previous Message Adrian Klaver 2022-09-13 19:41:25 Re: Postgresql acid components