Code bug or doc bug?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Code bug or doc bug?
Date: 2014-08-24 22:26:12
Message-ID: 53FA6684.5050407@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

Quoth our docs
(http://www.postgresql.org/docs/9.3/static/sql-alterdatabase.html):

"The fourth form changes the default tablespace of the database. Only
the database owner or a superuser can do this; you must also have create
privilege for the new tablespace. This command physically moves any
tables or indexes in the database's old default tablespace to the new
tablespace. Note that tables and indexes in non-default tablespaces are
not affected."

Yet:

jberkus=# alter database phc set tablespace ssd;
ERROR: some relations of database "phc" are already in tablespace "ssd"
HINT: You must move them back to the database's default tablespace
before using this command.

Aside from being a stupid limitation (I need to copy the tables back to
the old tablespace so that I can recopy them to the new one?), the above
seems to be in direct contradiction to the docs.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2014-08-25 01:44:23 Re: SKIP LOCKED DATA (work in progress)
Previous Message johnlumby 2014-08-24 21:49:31 Re: Extended Prefetching using Asynchronous IO - proposal and patch