public inbox for [email protected]help / color / mirror / Atom feed
Re: Latest patches break one of our unit-test, related to RLS 3+ messages / 2 participants [nested] [flat]
* Re: Latest patches break one of our unit-test, related to RLS @ 2025-09-04 15:12 Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Adrian Klaver @ 2025-09-04 15:12 UTC (permalink / raw) To: Dominique Devienne <[email protected]>; 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 [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Latest patches break one of our unit-test, related to RLS @ 2025-09-04 15:31 Dominique Devienne <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Dominique Devienne @ 2025-09-04 15:31 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: pgsql-general On Thu, Sep 4, 2025 at 5:12 PM Adrian Klaver <[email protected]> wrote: > On 9/4/25 08:03, Dominique Devienne wrote: > > 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? We first upgraded in place. Broke that test. We then re-installed fresh servers, minus-1 the latest patches. And verified the tests ran OK again,on these. We have several clusters on that machine. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Latest patches break one of our unit-test, related to RLS @ 2025-09-04 15:45 Dominique Devienne <[email protected]> parent: Dominique Devienne <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Dominique Devienne @ 2025-09-04 15:45 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: pgsql-general On Thu, Sep 4, 2025 at 5:31 PM Dominique Devienne <[email protected]> wrote: > On Thu, Sep 4, 2025 at 5:12 PM Adrian Klaver <[email protected]> wrote: > > On 9/4/25 08:03, Dominique Devienne wrote: > > > 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? > > We first upgraded in place. Broke that test. We're still naive I guess. And didn't expect a minor upgrade to break us... Given this mishap, we'll do the reverse from now on. Install fresh clusters for the new versions (minor or not), and see what happens. So we don't "advance" our main/primary (testing) clusters until "issues are resolved". ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-09-04 15:45 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-09-04 15:12 Re: Latest patches break one of our unit-test, related to RLS Adrian Klaver <[email protected]> 2025-09-04 15:31 ` Dominique Devienne <[email protected]> 2025-09-04 15:45 ` Dominique Devienne <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox