Latest patches break one of our unit-test, related to RLS

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Latest patches break one of our unit-test, related to RLS
Date: 2025-09-04 15:03:25
Message-ID: CAFCRh-8NwJd0jq6P=R3qhHyqU7hw0BTor3W0SvUcii24et+zAw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the same vein as v18betas breaking our unit-tests...
(we still don't understand, haven't looked much though).

OK, above it's about a major upgrade. So that's one thing.

But now, we've ascertain that a particular test is:

OK with 16.9 and 17.5 (we cannot test on beta2 anymore)
KO with 16.10 and 17.6 (and beta3 too, released at the same time)

Which for a minor patch is a surprise to us, not in a good way.

So... Did anything change around RLS in this patch series?
Anything changed around ROLE INHERIT rules?

The symptom is that a LOGIN user lacks ROLEs is used to have.
So perhaps some GRANTs are now silently doing nothing,
for some unknown reasons.

What in these patches could be affecting those areas?

Thanks, --DD

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-09-04 15:12:56 Re: Latest patches break one of our unit-test, related to RLS
Previous Message Adrian Klaver 2025-09-04 14:49:43 Re: In-order pg_dump (or in-order COPY TO)