Postgres Pro
Downloads
Home   >   mailing lists

Re: fixing CREATEROLE - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: fixing CREATEROLE
Date
Msg-id CAKFQuwbxsxDu-Mvbfqdu2F5eiNm6jjyY_Lc_H5G6+nwXjn6pKg@mail.gmail.com
Whole thread Raw
In response to Re: fixing CREATEROLE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: fixing CREATEROLE
List pgsql-hackers
Tree view
On Wed, Apr 30, 2025 at 1:29 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
But don't we need to add
createrole_self_grant to the set of GUCs that pg_dump[all]
resets in the emitted SQL?


The other approach would be to do what we do for the role options and just specify everything explicitly in the dump.  The GUC is only a default specifier so let's not leave room for defaults in the dump file.

David J.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance issues with v18 SQL-language-function changes
Next
From: Daniel Gustafsson
Date:
Subject: Re: Prevent an error on attaching/creating a DSM/DSA from an interrupt handler.