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

Commit5c7afb4

Browse files
committed
Doc: Improve clarity on partitioned table limitations
Explicitly mention that primary key constraints are also included in thelimitation that the constraint columns must be a superset of the partition keycolumns.Wording suggestion from Tom Lane.Discussion:https://postgr.es/m/64062533.78364.1601415362244@mail.yahoo.comBackpatch-through: 11, where unique constraints on partitioned tables were added
1 parent09b29ca commit5c7afb4

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

‎doc/src/sgml/ddl.sgml‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4050,8 +4050,8 @@ ALTER INDEX measurement_city_id_logdate_key
40504050

40514051
<listitem>
40524052
<para>
4053-
Unique constraints on partitioned tables must include all the
4054-
partition key columns. This limitation exists because
4053+
Unique constraints(and hence primary keys)on partitioned tables must
4054+
include all thepartition key columns. This limitation exists because
40554055
<productname>PostgreSQL</productname> can only enforce
40564056
uniqueness in each partition individually.
40574057
</para>

0 commit comments

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