Re: Latest patches break one of our unit-test, related to RLS - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Latest patches break one of our unit-test, related to RLS
Date
Msg-id 7132f28c-1437-4723-a363-c19b99a33bec@aklaver.com
Whole thread Raw
In response to Latest patches break one of our unit-test, related to RLS  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Latest patches break one of our unit-test, related to RLS
List pgsql-general
On 9/4/25 08:03, Dominique Devienne wrote:
> 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)

How did you move from one version to the other?

> 
> 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 are the GRANTs that are done to give the user the privileges?

> 
> What in these patches could be affecting those areas?
> 
> Thanks, --DD
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Latest patches break one of our unit-test, related to RLS
Next
From: Laurenz Albe
Date:
Subject: Re: Latest patches break one of our unit-test, related to RLS