SET SESSION AUTHORIZATION and log file entries - Mailing list pgsql-admin

From Achilleas Mantzios
Subject SET SESSION AUTHORIZATION and log file entries
Date
Msg-id 201012291606.41505.achill@matrix.gatewaynet.com
Whole thread Raw
Responses Re: SET SESSION AUTHORIZATION and log file entries  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
Hello,
i noticed that the user name as displayed in the postgresql log (specified by %u) in the log_line_prefix
does not show the user name of the effective user (current_user)as set by "SET SESSION AUTHORIZATION"
but, instead, shows the initial user which first authenticated against the said connection.
I think it would be better to have this user reported in the log files. (or have another entry e.g. %U to denote that)
--
Achilleas Mantzios

pgsql-admin by date:

Previous
From: Szymon Guz
Date:
Subject: Re: Finding missing values in sequence column
Next
From: nextage Tech
Date:
Subject: PostgreSQL