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)
pgsql-admin by date
|Next:||From: David Rericha||Date: 2010-12-29 17:11:39|
|Subject: Re: date out of range for timestamp|
|Previous:||From: Tom Lane||Date: 2010-12-29 03:06:13|
|Subject: Re: date out of range for timestamp |