Re: Yet more ROLE changes in v18 beta1???

On 6/4/25 06:52, Dominique Devienne wrote:

> Thanks, --DD
>
> PS: I'm not ruling out our code is at fault. Especially since we have
> conditional code based on the server version these days. But I'm
> pre-emptively asking for known changes in this area, to the experts.
>
> $ ./myruntests.csh tests_pdgm_schemas -t "..." --pq-version
> Connected to ... (17.4, server 18.0)

What is '(17.4, server 18.0)' referring to?

What is the actual test being run below?

> Running 1 test case...
> unknown location(0): fatal error: in "...": #42501: ERROR: 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:
> (1) : ... failed. #42501: ERROR: permission denied to drop role
> DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option
> on role "...:ADMIN" may drop this role.
>
>
> *** tests_pdgm_schemas in 1.790s (user: 0.290s) 52 MB
>
> $ vim .../postgres_test_config.xml
> $ ./myruntests.csh tests_pdgm_schemas -t "..." --pq-version
> Connected to ... (17.4, server 17.5)
> Running 1 test case...
>
> *** No errors detected
> *** tests_pdgm_schemas in 1.700s (user: 0.300s) 53 MB
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com