diff options
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index ed2d9c60d50..9301f0227d7 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -4005,6 +4005,15 @@ 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 + <productname>PostgreSQL</productname> can only enforce + uniqueness in each partition individually. + </para> + </listitem> + + <listitem> + <para> <literal>BEFORE ROW</literal> triggers, if necessary, must be defined on individual partitions, not the partitioned table. </para> |