On Oct 19, 2011, at 2:13 PM, Tom Lane wrote: >> ALTER ROLE dude WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN >> PASSWORD 'md5bdd7f8e73a214981b1519212b02a5530' VALID UNTIL 'infinity'; >> ALTER ROLE dude SET default_tablespace TO 'users'; > > I'm beginning to think that the correct solution to these problems is to > greatly restrict what you can set in ALTER ROLE/DATABASE SET. Or at > least to document that if you use it, you get to keep both pieces after > you break pg_dump.
Sorry, get to keep what two pieces? Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
