diff options
| author | David Rowley <drowley@postgresql.org> | 2020-09-30 13:03:01 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2020-09-30 13:03:01 +1300 |
| commit | 5610ffaf00a53877ec973881b9b0b7a1acad689a (patch) | |
| tree | cb8f532ddd6b9c1eacabbcea19331c7c93c284ae | |
| parent | f0e4ec74e452f55922b52f50da4ba4834771a268 (diff) | |
Doc: Improve clarity on partitioned table limitations
Explicitly mention that primary key constraints are also included in the
limitation that the constraint columns must be a superset of the partition key
columns.
Wording suggestion from Tom Lane.
Discussion: https://postgr.es/m/64062533.78364.1601415362244@mail.yahoo.com
Backpatch-through: 11, where unique constraints on partitioned tables were added
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 0ef55a0f79c..b5b16937d90 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -4056,8 +4056,8 @@ ALTER INDEX measurement_city_id_logdate_key <listitem> <para> - Unique constraints on partitioned tables must include all the - partition key columns. This limitation exists because + Unique constraints (and hence primary keys) on partitioned tables must + include all the partition key columns. This limitation exists because <productname>PostgreSQL</productname> can only enforce uniqueness in each partition individually. </para> |