Re: BUG #18389: pg_database_owner not recognized with alter default privileges - Mailing list pgsql-bugs

From Noah Misch
Subject Re: BUG #18389: pg_database_owner not recognized with alter default privileges
Date
Msg-id 20240312195517.23@rfd.leadboat.com
Whole thread Raw
In response to BUG #18389: pg_database_owner not recognized with alter default privileges  (PG Bug reporting form <noreply@postgresql.org>)
Responses AW: BUG #18389: pg_database_owner not recognized with alter default privileges
List pgsql-bugs
On Tue, Mar 12, 2024 at 07:04:11PM +0000, PG Bug reporting form wrote:
> Bug reference:      18389
> Logged by:          Marijo Kristo
> Email address:      m.kristo@rewe-group.at
> PostgreSQL version: 16.2
> Operating system:   Debian
> Description:        
> 
> Hello,
> 
> i am precreating schemas in template1 database and setting specific
> privileges.
> When performing "alter default privileges for role pg_database_owner ..."
> the group is recognized and the default privilege is also set. No error is
> thrown. 
> 
> When i create a new database the pg_database_owner role is not working
> correctly. I created then the same privilege with specifying the db owner
> and then the privilege works. 

Please share the exact SQL commands you used to reproduce this.




pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: A server crash with a SQL procedure returning a user-defined type on 14.8
Next
From: Noah Misch
Date:
Subject: Re: FSM Corruption (was: Could not read block at end of the relation)