Re: Today's Postgres Releases break login roles

From: Matthew Woodcraft <matthew(at)woodcraft(dot)me(dot)uk>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Etienne LAFARGE <etienne(dot)lafarge(at)gmail(dot)com>
Subject: Re: Today's Postgres Releases break login roles
Date: 2024-11-16 10:45:30
Message-ID: 87iksnsbhx.fsf@golux.woodcraft.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Etienne LAFARGE <etienne(dot)lafarge(at)gmail(dot)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.

I noticed one other change with the 14.14 point release, which I think
is likely to be related.

Previously a command like this would work to select a role immediately after
login:

psql "options='-crole=foo'"

With 14.14 as far as I can tell it has no effect.

-M-

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2024-11-16 11:00:00 Re: BUG #18708: regex problem: (?:[^\d\D]){0} asserts with "lp->nouts == 0 && rp->nins == 0"
Previous Message Noah Misch 2024-11-16 04:53:58 Re: Today's Postgres Releases break login roles