diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-07-10 08:58:41 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-07-10 09:12:28 -0400 |
| commit | 220857a87508fdac3fd4caf5f344a8fe9e70702d (patch) | |
| tree | 6acba8ba227a839f03c9061aeb370ab54481c39d | |
| parent | a5c2f3a346fcda21d3dc9227b2c07854a7973729 (diff) | |
Mention limitation of unique in partitioned tables
Per gripe from Phil Bayer.
Authors: Amit Langote and others
Discussion: https://postgr.es/m/156236160709.1192.4498528196556144085@wrigleys.postgresql.org
| -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> |