Doc: Improve clarity on partitioned table limitations

david-rowley · david-rowley · commit ab0c9c073563 · 2020-09-30T13:05:18.000+13:00
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
diff --git 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>
