On Wed, Jul 27, 2011 at 7:51 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Phil Sorber <p...@omniti.com> writes: >> Currently if you use 'ALTER ROLE rolename SET ROLE', pg_dumpall will >> dump an 'ALTER ROLE' out right after the 'CREATE ROLE' statement. > > I think pg_dumpall is the very least of your problems if you do > something like that. We probably ought to forbid it entirely.
Well, we had a long discussion of that on the thread Phil linked to, and I don't think there was any consensus that forbidding it was the right thing to do. Phil appears to be trying to implement the proposal you made here: http://archives.postgresql.org/pgsql-hackers/2011-01/msg00452.php ...although I don't think that what he did quite matches what you asked for. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
