| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | m(dot)kristo(at)rewe-group(dot)at, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18389: pg_database_owner not recognized with alter default privileges |
| Date: | 2024-03-12 19:55:17 |
| Message-ID: | 20240312195517.23@rfd.leadboat.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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 share the exact SQL commands you used to reproduce this.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2024-03-12 22:08:07 | Re: FSM Corruption (was: Could not read block at end of the relation) |
| Previous 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 |