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:49 -0400 |
| commit | ec4eaab78b078b9326296236f184773590a92ca3 (patch) | |
| tree | cc547af083ba2eb901fbcec4c29998573722dd6c /doc/src | |
| parent | fa19a08d71fbeefc39415d9c6c70128460d41f94 (diff) | |
| download | postgresql-ec4eaab78b078b9326296236f184773590a92ca3.tar.gz postgresql-ec4eaab78b078b9326296236f184773590a92ca3.zip | |
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
Diffstat (limited to 'doc/src')
| -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> |