postgres.git / summary / log / commit / refs

commit    896cedc7d578b9fd9c966f87a32ec628ee6c01aa
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Thu Apr 29 15:31:24 2021 +0000
First released in: 14.0, 12.7, 13.3

    Improve documentation for default_tablespace on partitioned tables
    
    Backpatch to 12, where 87259588d0ab 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


 doc/src/sgml/config.sgml | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 28fd0670f76..136b51bf122 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -7937,8 +7937,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
        <para>
         This variable specifies the default tablespace in which to create
         objects (tables and indexes) when a <command>CREATE</command> command does
-        not explicitly specify a tablespace.  It also determines the tablespace
-        that a partitioned relation will direct future partitions to.
+        not explicitly specify a tablespace.
        </para>
 
        <para>
@@ -7962,6 +7961,14 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
         the template database it is copied from.
        </para>
 
+       <para>
+        If this parameter is set to a value other than the empty string
+        when a partitioned table is created, the partitioned table's
+        tablespace will be set to that value, which will be used as
+        the default tablespace for partitions created in the future,
+        even if <varname>default_tablespace</varname> has changed since then.
+       </para>
+
        <para>
         For more information on tablespaces,
         see <xref linkend="manage-ag-tablespaces"/>.


[parent: 7bbcfb4d584d]