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: Noah Misch <noah@leadboat.com>
Cc: Matthew Woodcraft <matthew@woodcraft.me.uk>, pgsql-bugs@lists.postgresql.org, Etienne LAFARGE <etienne.lafarge@gmail.com>
Date: 2024-11-16T20:11:11Z
Lists: pgsql-bugs 
Noah Misch <noah@leadboat.com> writes:
> Agreed.  I cut some corners by not directly testing that or ALTER DATABASE, so
> here are some more tests.  The output is the same on master @ now, on master @
> 2024-11-10 (before the regression), and on v12.  It reproduces the trouble on
> master @ 2024-11-12.  That's sufficient confirmation for the moment, so I'll
> hold this until the releases wrap and make it master-only.

If you only intend to apply it to master, there's no need to wait.

			regards, tom lane

Commits

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

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