On Wed, Aug 27, 2014 at 06:39:21AM -0700, David G Johnston wrote:
> > Is there a doc patch to make here?
>
> 1. Last sentence change suggestion: "The target tablespace must be empty."
>
> 2. Based on Robert's comments it sounds like a "You cannot change the
> default tablespace of the current database." comment should be added as
> well.
>
> Side note: I have no clue what the "mapped relations" Robert refers to
> are...
I have created the attached doc patch for this. Should we backpatch
this through 9.0, or just 9.4?
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml
new file mode 100644
index 3724c05..4af441e
*** a/doc/src/sgml/ref/alter_database.sgml
--- b/doc/src/sgml/ref/alter_database.sgml
*************** ALTER DATABASE <replaceable class="PARAM
*** 77,84 ****
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.
</para>
<para>
--- 77,86 ----
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. The new tablespace for
! this database must be empty, and no one can be connected to the
! database. Tables and indexes in non-default tablespaces are not
! affected.
</para>
<para>
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
