diff options
| author | Andres Freund <andres@anarazel.de> | 2015-11-09 05:08:56 +0100 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2015-11-09 06:58:26 +0100 |
| commit | 90e074baec2f052120271437a72d2ef6d1de1696 (patch) | |
| tree | b76bbe8e2e775e72704a96a915e2e9834a235452 | |
| parent | 04c0b63365c7d4ee584300737afe6ef7df3b1253 (diff) | |
| download | postgresql-90e074baec2f052120271437a72d2ef6d1de1696.tar.gz postgresql-90e074baec2f052120271437a72d2ef6d1de1696.zip | |
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
| -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 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> |