diff options
| author | David Rowley <drowley@postgresql.org> | 2020-09-30 13:05:18 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2020-09-30 13:05:18 +1300 |
| commit | ab0c9c073563c61f9761d8d5fa02ea070a55cb85 (patch) | |
| tree | 28957d209b271ae95745e6bcdab73a6480d6489a | |
| parent | c2a29aee7246932125d86d3dff192cd5db9ee678 (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 18155f1a475..27922867a7a 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -3460,8 +3460,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> |