postgres.git / summary / log / commit / refs

commit    90e074baec2f052120271437a72d2ef6d1de1696
Author:   Andres Freund <andres@anarazel.de>
Date:     Mon Nov 09 04:08:56 2015 +0000
First released in: 9.6.0, 9.5.0

    Add paragraph about ON CONFLICT interaction with partitioning.
    
    Author: Peter Geoghegan and Andres Freund
    Discussion: CAM3SWZScpWzQ-7EJC77vwqzZ1GO8GNmURQ1QqDQ3wRn7AbW1Cg@mail.gmail.com,
        CAHGQGwFUCWwSU7dtc2aRdRk73ztyr_jY5cPOyts+K8xKJ92X4Q@mail.gmail.com
    Backpatch: 9.5, where UPSERT was introduced


 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 fe5a076fe12..58a2e9b36e5 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -3246,6 +3246,15 @@ ANALYZE measurement;
      </para>
     </listitem>
 
+    <listitem>
+     <para>
+      <command>INSERT</command> statements with <literal>ON CONFLICT</>
+      clauses are unlikely to work as expected, as the <literal>ON CONFLICT</>
+      action is only taken in case of unique violations on the specified
+      target relation, not its child relations.
+     </para>
+    </listitem>
+
    </itemizedlist>
    </para>
 


[parent: 04c0b63365c7]