Commit97d5548

committed

doc: restrictions on alter database moving default tablespace

Mention tablespace must be empty and no one connected to the database.Report by Josh Berkus

1 parent52c1ae2 commit97d5548Copy full SHA for 97d5548

File tree

-2

lines changed

-2

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -77,8 +77,10 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL`
`77`	`77`	`Only the database owner or a superuser can do this; you must also have`
`78`	`78`	`create privilege for the new tablespace.`
`79`	`79`	`This command physically moves any tables or indexes in the database's old`
`80`		`- default tablespace to the new tablespace. Note that tables and indexes`
`81`		`- in non-default tablespaces are not affected.`
	`80`	`+ default tablespace to the new tablespace. The new default tablespace`
	`81`	`+ for this database must be empty, and no one can be connected to`
	`82`	`+ the database. Tables and indexes in non-default tablespaces are`
	`83`	`+ unaffected.`
`82`	`84`	`</para>`
`83`	`85`
`84`	`86`	`<para>`

Comments

(0)