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.klaver@aklaver.com