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:57:21 +0100 |
| commit | c31f1dc55992bc8b2c35c0ff99795547d4df323a (patch) | |
| tree | 0330c23ae5f93e55899e1dedcb782e866b2377a0 | |
| parent | f3a764b0dac77451d20ee00d2f5916447a5c4346 (diff) | |
| download | postgresql-c31f1dc55992bc8b2c35c0ff99795547d4df323a.tar.gz postgresql-c31f1dc55992bc8b2c35c0ff99795547d4df323a.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 a889ffc5472..449b54fa67c 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> |