pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Noah Misch <noah@leadboat.com>
To: Etienne LAFARGE <etienne.lafarge@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Today's Postgres Releases break login roles
Date: Fri, 15 Nov 2024 20:53:58 -0800
Message-ID: <20241116045358.1e.nmisch@google.com> (raw)
In-Reply-To: <2629829.1731714840@sss.pgh.pa.us>
References: <CADOZwSb0UsEr4_UTFXC5k7=fyyK8uKXekucd+-uuGjJsGBfxgw@mail.gmail.com>
	<2629829.1731714840@sss.pgh.pa.us>

On Fri, Nov 15, 2024 at 06:54:00PM -0500, Tom Lane wrote:
> 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.

Per https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-november-21-2024-2958/
we're issuing releases next Thursday to fix this and fix a separate ABI break.
I've pushed postgr.es/c/7b88529 for $SUBJECT.  To maximize time-in-buildfarm,
I've pushed it without a public comment period.  I welcome post-commit review,
and I'm happy to amend the change if anyone finds something that would have
been cause for change during a standard opportunity for pre-commit review.
That said, given our wrap schedule, feedback after Saturday is less likely to
change next week's releases.  Such feedback could still affect the 2025-02
releases, of course.

I overlooked this consequence of the 2024-11-14 change.  I apologize.





view thread (9+ messages)  latest in thread

Message-ID: <20241116045358.1e.nmisch@google.com>
Permalink:  ../20241116045358.1e.nmisch@google.com/
Also on:    postgresql.org/message-id/20241116045358.1e.nmisch@google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noah@leadboat.com, etienne.lafarge@gmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
  Subject: Re: Today's Postgres Releases break login roles
  In-Reply-To: <20241116045358.1e.nmisch@google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox