diff options
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index c85e92b3a2f..e49d19716c1 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -4057,12 +4057,13 @@ ALTER INDEX measurement_city_id_logdate_key <itemizedlist> <listitem> <para> - Unique constraints (and hence primary keys) on partitioned tables must - include all the partition key columns. This limitation exists because - the individual indexes making up the constraint can only directly - enforce uniqueness within their own partitions; therefore, the - partition structure itself must guarantee that there are not - duplicates in different partitions. + To create a unique or primary key constraint on a partitioned table, + the partition keys must not include any expressions or function calls + and the constraint's columns must include all of the partition key + columns. This limitation exists because the individual indexes making + up the constraint can only directly enforce uniqueness within their own + partitions; therefore, the partition structure itself must guarantee + that there are not duplicates in different partitions. </para> </listitem> |