Movatterモバイル変換

[0]ホーム
URL:

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

 Sign up
Appearance settings

Commitb25d47b

Browse files
committed
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 MasaoReviewed-by: Amit LangoteDiscussion:https://postgr.es/m/CAHGQGwEs-59omrfGF7hOHz9iMME3RbKy5ny+iftDx3LHTEn9sA@mail.gmail.com
1 parentc4a2041 commitb25d47b

File tree

1 file changed

+2
-1
lines changed

1 file changed

+2
-1
lines changed

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -539,7 +539,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
539539
additional <literal>CHECK</literal> constraints; additional constraints with
540540
the same name and condition as in the parent will be merged with the
541541
parent constraint. Defaults may be specified separately for each
542-
partition.
542+
partition. But note that a partition's default value is not applied
543+
when inserting a tuple through a partitioned table.
543544
</para>
544545

545546
<para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp