BUG #18389: pg_database_owner not recognized with alter default privileges

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: m(dot)kristo(at)rewe-group(dot)at
Subject: BUG #18389: pg_database_owner not recognized with alter default privileges
Date: 2024-03-12 19:04:11
Message-ID: 18389-8ad7f569523f579b@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18389
Logged by: Marijo Kristo
Email address: m(dot)kristo(at)rewe-group(dot)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, check this. Thank you !

Br
Marijo Kristo

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-03-12 19:50:43 Re: A server crash with a SQL procedure returning a user-defined type on 14.8
Previous Message ocean_li_996 2024-03-12 15:07:22 Re:RE: Re:RE: Re:RE: Re:BUG #18369: logical decoding core on AssertTXNLsnOrder()