diff options
| author | David Rowley <drowley@postgresql.org> | 2020-09-30 13:02:08 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2020-09-30 13:02:08 +1300 |
| commit | 2b888647d864c5341fd0fb628c3773304282dc1d (patch) | |
| tree | 3d72eb3aad045c4d44cb5273a7f21002cdbcb9ba | |
| parent | a094c8ff53523e88ff9dd28ad467618039e27b58 (diff) | |
| download | postgresql-2b888647d864c5341fd0fb628c3773304282dc1d.tar.gz postgresql-2b888647d864c5341fd0fb628c3773304282dc1d.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 e890bdd10ad..9fb2be6674f 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> |