Feedback-ID: i76984098:Fastmail
Message-ID: <5ad6900d-dab4-4c90-a156-40237717902c@aklaver.com>
Date: Wed, 4 Jun 2025 08:29:44 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Yet more ROLE changes in v18 beta1???
To: Dominique Devienne <ddevienne@gmail.com>, pgsql-general@postgresql.org
Cc: robertmhaas@gmail.com
References: <CAFCRh-_gUzbsUcr0LAazQZKYn4Mp-HrbgJXiybokM-GVTSZ=pg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFCRh-_gUzbsUcr0LAazQZKYn4Mp-HrbgJXiybokM-GVTSZ=pg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/5ad6900d-dab4-4c90-a156-40237717902c%40aklaver.com>
Precedence: bulk

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