MIME-Version: 1.0
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> <1124024.1749092239@sss.pgh.pa.us>
In-Reply-To: <1124024.1749092239@sss.pgh.pa.us>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Thu, 31 Jul 2025 14:34:47 +0200
Message-ID: <CAFCRh-_Q_XXntV7NvtJEoaZYZ_neCcwy-cduoQoF9naGVO4O6A@mail.gmail.com>
Subject: Re: Yet more ROLE changes in v18 beta1???
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-general@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-_Q_XXntV7NvtJEoaZYZ_neCcwy-cduoQoF9naGVO4O6A%40mail.gmail.com>
Precedence: bulk

On Thu, Jun 5, 2025 at 4:57=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Dominique Devienne <ddevienne@gmail.com> 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=3DC:\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=3DC:\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=3DC:\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
```