On Sat, Oct 18, 2014 at 02:23:46PM +0000, Bruce Momjian wrote:
> doc: restrictions on alter database moving default tablespace
>
> Mention tablespace must be empty and no one connected to the database.
The database must not contain any object explicitly assigned to its future
default tablespace, but that tablespace need not be empty. Objects of other
databases in the tablespace pose no problem.