Re: pg_dumpall Sets Roll default_tablespace Before Creating Tablespaces

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