diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-10-18 10:23:42 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-10-18 10:23:42 -0400 |
| commit | 97d554871c3d186db831b35c0eabe6d496e4f54b (patch) | |
| tree | b32e2996c51a515a0933e2bbbbc27913466a34f1 | |
| parent | 52c1ae22d6a4daf1c1c01fc9244f8ebae5402b1a (diff) | |
| download | postgresql-97d554871c3d186db831b35c0eabe6d496e4f54b.tar.gz postgresql-97d554871c3d186db831b35c0eabe6d496e4f54b.zip | |
doc: restrictions on alter database moving default tablespace
Mention tablespace must be empty and no one connected to the database.
Report by Josh Berkus
| -rw-r--r-- | doc/src/sgml/ref/alter_database.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 3724c05e2c0..333db5b1c20 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -77,8 +77,10 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL 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. + default tablespace to the new tablespace. The new default tablespace + for this database must be empty, and no one can be connected to + the database. Tables and indexes in non-default tablespaces are + unaffected. </para> <para> |