postgres.git / summary / log / commit / refs

commit    220857a87508fdac3fd4caf5f344a8fe9e70702d
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Wed Jul 10 12:58:41 2019 +0000
First released in: 13.0, 11.5, 12.0

    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


 doc/src/sgml/ddl.sgml | 9 +++++++++
 1 file changed, 9 insertions(+)

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
@@ -4003,6 +4003,15 @@ ALTER INDEX measurement_city_id_logdate_key
       </para>
      </listitem>
 
+     <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


[parent: a5c2f3a346fc]