Commit94b9cb7

and

committed

Improve documentation for default_tablespace on partitioned tables

Backpatch to 12, where8725958 introduced the current behavior.Per note from Justin Pryzby.Co-authored-by: Justin Pryzby <pryzby@telsasoft.com>Discussion:https://postgr.es/m/20210416143135.GI3315@telsasoft.com

1 parentd9a9f4b commit94b9cb7Copy full SHA for 94b9cb7

File tree

-2

lines changed

-2

lines changed

Lines changed: 9 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8268,8 +8268,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;`
`8268`	`8268`	`<para>`
`8269`	`8269`	`This variable specifies the default tablespace in which to create`
`8270`	`8270`	`objects (tables and indexes) when a <command>CREATE</command> command does`
`8271`		`- not explicitly specify a tablespace. It also determines the tablespace`
`8272`		`- that a partitioned relation will direct future partitions to.`
	`8271`	`+ not explicitly specify a tablespace.`
`8273`	`8272`	`</para>`
`8274`	`8273`
`8275`	`8274`	`<para>`
`@@ -8293,6 +8292,14 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;`
`8293`	`8292`	`the template database it is copied from.`
`8294`	`8293`	`</para>`
`8295`	`8294`
	`8295`	`+ <para>`
	`8296`	`+ If this parameter is set to a value other than the empty string`
	`8297`	`+ when a partitioned table is created, the partitioned table's`
	`8298`	`+ tablespace will be set to that value, which will be used as`
	`8299`	`+ the default tablespace for partitions created in the future,`
	`8300`	`+ even if <varname>default_tablespace</varname> has changed since then.`
	`8301`	`+ </para>`
	`8302`	`+`
`8296`	`8303`	`<para>`
`8297`	`8304`	`For more information on tablespaces,`
`8298`	`8305`	`see <xref linkend="manage-ag-tablespaces"/>.`

Comments

(0)