From: Noah Misch <noah@leadboat.com>
To: m.kristo@rewe-group.at
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18389: pg_database_owner not recognized with alter default privileges
Date: Tue, 12 Mar 2024 12:55:17 -0700
Message-ID: <20240312195517.23@rfd.leadboat.com> (raw)
In-Reply-To: <18389-8ad7f569523f579b@postgresql.org>
References: <18389-8ad7f569523f579b@postgresql.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noah@leadboat.com, m.kristo@rewe-group.at, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18389: pg_database_owner not recognized with alter default privileges
In-Reply-To: <20240312195517.23@rfd.leadboat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox