Based on the feedback here, I have returned this patch to Needs Review status. (Waiting on Author would be fairer actually, since we are waiting for an updated version.)
As far as I can make it from Noah and Robert's comments, what we would like to see here is a way for pg_dump to output nondefault grants to system objects; that would solve part of the need here where this patch proposes default roles for one or two system objects. Another part of this patch, which could presumably be committed independently, is the addition of default roles that are related to larger sets of system objects. -- Á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
