Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 94b9cb7

Browse filesBrowse files
Improve documentation for default_tablespace on partitioned tables
Backpatch to 12, where 8725958 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 parent d9a9f4b commit 94b9cb7
Copy full SHA for 94b9cb7

File tree

Expand file treeCollapse file tree

1 file changed

+9
-2
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+9
-2
lines changed

‎doc/src/sgml/config.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/config.sgml
+9-2Lines changed: 9 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8268,8 +8268,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
82688268
<para>
82698269
This variable specifies the default tablespace in which to create
82708270
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.
82738272
</para>
82748273

82758274
<para>
@@ -8293,6 +8292,14 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
82938292
the template database it is copied from.
82948293
</para>
82958294

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+
82968303
<para>
82978304
For more information on tablespaces,
82988305
see <xref linkend="manage-ag-tablespaces"/>.

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.