public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dominique Devienne <[email protected]>
To: Tom Lane <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: [email protected]
Subject: Re: Yet more ROLE changes in v18 beta1???
Date: Thu, 31 Jul 2025 14:34:47 +0200
Message-ID: <CAFCRh-_Q_XXntV7NvtJEoaZYZ_neCcwy-cduoQoF9naGVO4O6A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFCRh-_gUzbsUcr0LAazQZKYn4Mp-HrbgJXiybokM-GVTSZ=pg@mail.gmail.com>
<CA+TgmoYEVWid5Mor2img6sQOD7NK+gv71MGBxig7-RqGp1+B4Q@mail.gmail.com>
<CAFCRh-_bT_05c2=WySpKmzvf0KA_rLtdc1LOcjTZDZFmSUsW9Q@mail.gmail.com>
<[email protected]>
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
```
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Yet more ROLE changes in v18 beta1???
In-Reply-To: <CAFCRh-_Q_XXntV7NvtJEoaZYZ_neCcwy-cduoQoF9naGVO4O6A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox