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 896cedc

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 7bbcfb4 commit 896cedc
Copy full SHA for 896cedc

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
@@ -7937,8 +7937,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
79377937
<para>
79387938
This variable specifies the default tablespace in which to create
79397939
objects (tables and indexes) when a <command>CREATE</command> command does
7940-
not explicitly specify a tablespace. It also determines the tablespace
7941-
that a partitioned relation will direct future partitions to.
7940+
not explicitly specify a tablespace.
79427941
</para>
79437942

79447943
<para>
@@ -7962,6 +7961,14 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
79627961
the template database it is copied from.
79637962
</para>
79647963

7964+
<para>
7965+
If this parameter is set to a value other than the empty string
7966+
when a partitioned table is created, the partitioned table's
7967+
tablespace will be set to that value, which will be used as
7968+
the default tablespace for partitions created in the future,
7969+
even if <varname>default_tablespace</varname> has changed since then.
7970+
</para>
7971+
79657972
<para>
79667973
For more information on tablespaces,
79677974
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.