postgres.git / summary / log / commit / refs

commit    b25d47b61896b313dfa0517bc8831ae355e711cd
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Thu Dec 26 06:07:43 2019 +0000
First released in: 10.12, 11.7, 12.2

    Add note about how each partition's default value is treated, into the doc.
    
    Column defaults may be specified separately for each partition.
    But INSERT via a partitioned table ignores those partition's default values.
    The former is documented, but the latter restriction not.
    This commit adds the note about that restriction into the document.
    
    Back-patch to v10 where partitioning was introduced.
    
    Author: Fujii Masao
    Reviewed-by: Amit Langote
    Discussion: https://postgr.es/m/CAHGQGwEs-59omrfGF7hOHz9iMME3RbKy5ny+iftDx3LHTEn9sA@mail.gmail.com


 doc/src/sgml/ref/create_table.sgml | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 4f27daf1ae6..8ff5cb6136d 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -539,7 +539,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
       additional <literal>CHECK</literal> constraints; additional constraints with
       the same name and condition as in the parent will be merged with the
       parent constraint.  Defaults may be specified separately for each
-      partition.
+      partition. But note that a partition's default value is not applied
+      when inserting a tuple through a partitioned table.
      </para>
 
      <para>


[parent: c4a2041a43c9]