public inbox for [email protected]help / color / mirror / Atom feed
Re: Yet more ROLE changes in v18 beta1??? 3+ messages / 2 participants [nested] [flat]
* Re: Yet more ROLE changes in v18 beta1??? @ 2025-06-05 02:57 Tom Lane <[email protected]> 2025-07-31 12:34 ` Re: Yet more ROLE changes in v18 beta1??? Dominique Devienne <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2025-06-05 02:57 UTC (permalink / raw) To: Dominique Devienne <[email protected]>; +Cc: Robert Haas <[email protected]>; pgsql-general Dominique Devienne <[email protected]> writes: > Unfortunately, digging into this is not something I can do right away. > v18 is still a few months out, I do hope I can investigate before that. It'd be good if you could prioritize that a bit more. If there is a bug rather than an intentional change here, we'd much rather find it and fix it before 18.0 comes out. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Yet more ROLE changes in v18 beta1??? 2025-06-05 02:57 Re: Yet more ROLE changes in v18 beta1??? Tom Lane <[email protected]> @ 2025-07-31 12:34 ` Dominique Devienne <[email protected]> 2025-09-26 14:19 ` Re: Yet more ROLE changes in v18 beta1??? Dominique Devienne <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Dominique Devienne @ 2025-07-31 12:34 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Robert Haas <[email protected]>; pgsql-general On Thu, Jun 5, 2025 at 4:57 AM Tom Lane <[email protected]> wrote: > Dominique Devienne <[email protected]> writes: > > Unfortunately, digging into this is not something I can do right away. > > v18 is still a few months out, I do hope I can investigate before that. > > It'd be good if you could prioritize that a bit more. If there is > a bug rather than an intentional change here, we'd much rather > find it and fix it before 18.0 comes out. Of course Tom. And as a quick update, we've installed beta2 now, but still get the same v18-specific failure, compared to v17 and v16 (see below). I'll be looking at this soon. And will report back. --DD ``` D:\>set POSTGRESQL_UTCONFIG=C:\Users\ddevienne\ut_pg_config-18.json D:\>tests_schemas -t ... --pq-version Connected to postgresql://ddevienne@.../ddevienne (17.4, server 18.0) Running 1 test case... unknown location(0): fatal error: in "...": class pq::Error: #42501 permission denied to drop role DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "...:ADMIN" may drop this role. *** 1 failure is detected in the test module "Master Test Suite" *** failure detail: *** tests_schemas in 0.596s (user: 0.062s) 23 MB D:\>set POSTGRESQL_UTCONFIG=C:\Users\ddevienne\ut_pg_config-17.json D:\>tests_schemas -t ... --pq-version Connected to postgresql://ddevienne@.../ddevienne (17.4, server 17.5) Running 1 test case... *** No errors detected *** tests_schemas in 0.706s (user: 0.062s) 25 MB D:\>set POSTGRESQL_UTCONFIG=C:\Users\ddevienne\ut_pg_config-16.json D:\>tests_schemas -t ... --pq-version Connected to postgresql://ddevienne@.../ddevienne (17.4, server 16.9) Running 1 test case... *** No errors detected *** tests_schemas in 0.612s (user: 0.047s) 26 MB ``` ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Yet more ROLE changes in v18 beta1??? 2025-06-05 02:57 Re: Yet more ROLE changes in v18 beta1??? Tom Lane <[email protected]> 2025-07-31 12:34 ` Re: Yet more ROLE changes in v18 beta1??? Dominique Devienne <[email protected]> @ 2025-09-26 14:19 ` Dominique Devienne <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Dominique Devienne @ 2025-09-26 14:19 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Robert Haas <[email protected]>; pgsql-general On Thu, Jul 31, 2025 at 2:34 PM Dominique Devienne <[email protected]> wrote: > On Thu, Jun 5, 2025 at 4:57 AM Tom Lane <[email protected]> wrote: > > Dominique Devienne <[email protected]> writes: > > > Unfortunately, digging into this is not something I can do right away. > > > v18 is still a few months out, I do hope I can investigate before that. > > > > It'd be good if you could prioritize that a bit more. If there is > > a bug rather than an intentional change here, we'd much rather > > find it and fix it before 18.0 comes out. > > Of course Tom. And as a quick update, we've installed beta2 now, but > still get the same v18-specific failure, compared to v17 and v16 (see > below). I'll be looking at this soon. And will report back. --DD To close out this thread, I'm happy to report that all is well with v18 official. Came a bit as a surprise, given our poor experience with betas and the RC, but magically all tests pass on the official v18. So a GOOD surprise! It's not impossible this is due to recent (unrelated) changes on our end... Good thing I never investigated these v18beta/rc failures, I guess. --DD ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-09-26 14:19 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-06-05 02:57 Re: Yet more ROLE changes in v18 beta1??? Tom Lane <[email protected]> 2025-07-31 12:34 ` Dominique Devienne <[email protected]> 2025-09-26 14:19 ` 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