Re: SET SESSION AUTHORIZATION command doesn't update status of backend

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: SET SESSION AUTHORIZATION command doesn't update status of backend
Date: 2021-10-15 13:50:05
Message-ID: 952987.1634305805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andrey V. Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> writes:
> Nikita Degtyarev (n(dot)degtyarev(at)postgrespro(dot)ru) reported a suspicious
> behaviour of a SET SESSION AUTHORIZATION command. If you switch user in
> a session:
> [ pg_stat_activity doesn't change ]

I don't think this is a bug. pg_stat_activity is reporting the session's
login identity, and that seems fine, though maybe the documentation about
it needs to be clarified.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Dunstan 2021-10-15 14:46:03 Re: BUG #17212: pg_amcheck fails on checking temporary relations
Previous Message Andrey V. Lepikhov 2021-10-15 06:19:20 SET SESSION AUTHORIZATION command doesn't update status of backend