Re: Yet more ROLE changes in v18 beta1??? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Yet more ROLE changes in v18 beta1???
Date
Msg-id 5ad6900d-dab4-4c90-a156-40237717902c@aklaver.com
Whole thread Raw
In response to Yet more ROLE changes in v18 beta1???  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Yet more ROLE changes in v18 beta1???
List pgsql-general
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




pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Yet more ROLE changes in v18 beta1???
Next
From: Tom Lane
Date:
Subject: Re: Yet more ROLE changes in v18 beta1???