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

Commit2b88864

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 parenta094c8f commit2b88864

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
@@ -4056,8 +4056,8 @@ ALTER INDEX measurement_city_id_logdate_key
40564056

40574057
<listitem>
40584058
<para>
4059-
Unique constraints on partitioned tables must include all the
4060-
partition key columns. This limitation exists because
4059+
Unique constraints(and hence primary keys)on partitioned tables must
4060+
include all thepartition key columns. This limitation exists because
40614061
<productname>PostgreSQL</productname> can only enforce
40624062
uniqueness in each partition individually.
40634063
</para>

0 commit comments

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