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