Horton

Re: Today's Postgres Releases break login roles

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Etienne LAFARGE <etienne.lafarge@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2024-11-15T23:54:00Z
Lists: pgsql-bugs 
Etienne LAFARGE <etienne.lafarge@gmail.com> writes:
> Today, when upgrading from Postgres 15.8 to 15.9, we realized that the
> login role set for a user (with ALTER USER my_user SET ROLE my_role) was
> not automatically set upon login any more.

Right, that was not intended.  We'll fix it next week.

			regards, tom lane

Commits

  1. Test "options=-crole=" and "ALTER DATABASE SET role".

  2. Fix per-session activation of ALTER {ROLE|DATABASE} SET role.