On Wed, Apr 30, 2025 at 5:16 PM David G. Johnston <david.g.johns...@gmail.com> wrote: > On Wed, Apr 30, 2025 at 1:29 PM Tom Lane <t...@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.
+1 for considering that option, although I am not sure which way is better. -- Robert Haas EDB: http://www.enterprisedb.com