diff options
| author | Fujii Masao <fujii@postgresql.org> | 2019-12-26 15:07:43 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2019-12-26 15:07:43 +0900 |
| commit | 1ab029d528dcb409fb371d5ad826a67ec78b2b4e (patch) | |
| tree | 5d952c2542c7faed0e253223ea56b9145d1b6f5a | |
| parent | bb4114a4e2c65f27931cc074214c051dba2876c3 (diff) | |
| download | postgresql-1ab029d528dcb409fb371d5ad826a67ec78b2b4e.tar.gz postgresql-1ab029d528dcb409fb371d5ad826a67ec78b2b4e.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 2 |
1 files changed, 2 insertions, 0 deletions
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> |