From 1ab029d528dcb409fb371d5ad826a67ec78b2b4e Mon Sep 17 00:00:00 2001
From: Fujii Masao
Date: Thu, 26 Dec 2019 15:07:43 +0900
Subject: 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.

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 | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index e9a31aa257e..4a2b6f0dae8 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -539,6 +539,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
       <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.
+      But note that a partition's default value is not applied when inserting
+      a tuple through a partitioned table.
      </para>
 
      <para>
-- 
cgit v1.2.3