Robert Haas wrote: > On Mon, Apr 25, 2016 at 6:55 PM, Stephen Frost <sfr...@snowman.net> wrote:
> > Working up a patch to remove these checks should be pretty quickly done > > (iirc, I've actually got an independent patch around from when I added > > them, just need to find it and then go through the committed patches to > > make sure I take care of everything), but would like to make sure that > > we're now all on the same page and that *all* of these checks should be > > removed, making default roles just exactly like "regular" roles, except > > that they're created at initdb time and have "special" rights provided > > by C-level code checks. > > That's what I'm thinking. I would welcome other views. I agree with that view, assuming pg_dump correctly produces GRANTs to replicate what was done in a database regarding those roles (and same with pg_dumpall -g). I think it already works that way, but I may be mistaken. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers