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.