BUG #5184: default tablespace owner is not dumped - Mailing list pgsql-bugs

From Robert Haas
Subject BUG #5184: default tablespace owner is not dumped
Date
Msg-id 200911130534.nAD5YK4D029893@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5184: default tablespace owner is not dumped  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5184
Logged by:          Robert Haas
Email address:      robertmhaas@gmail.com
PostgreSQL version: CVS HEAD
Operating system:   Linux
Description:        default tablespace owner is not dumped
Details:

The following command does not change the output of "pg_dumpall":

alter tablespace pg_default owner to bob;

But this one does:

alter tablespace foo owner to bob;

The problem is that we only emit CREATE TABLESPACE commands for non-system
tablespaces.  That is correct, but it seems like we might need to emit ALTER
TABLESPACE commands instead for system tablespaces.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5183: Wrong select results using multicolumn gin indexes
Next
From: Tom Lane
Date:
Subject: Re: BUG #5184: default tablespace owner is not dumped