diff options
| author | David Rowley <drowley@postgresql.org> | 2020-09-30 13:03:34 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2020-09-30 13:04:13 +1300 |
| commit | 5c7afb4a29aa0f75def751406b4004e7f047a7f3 (patch) | |
| tree | 73531d5f46807084890de11403521e247a4ffba6 | |
| parent | 09b29ca82bc8be2e8b2f9ef74d12425b765b40ee (diff) | |
| download | postgresql-5c7afb4a29aa0f75def751406b4004e7f047a7f3.tar.gz postgresql-5c7afb4a29aa0f75def751406b4004e7f047a7f3.zip | |
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 0c2aedc361a..1e60bdb6ef1 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -4050,8 +4050,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> |