Horton

Allow ON CONFLICT .. DO NOTHING on a partitioned table.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 8355a011a0124bdf7ccbada206a967d427039553
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-03-27T14:37:41Z
Releases: 10.0 
Allow ON CONFLICT .. DO NOTHING on a partitioned table.

ON CONFLICT .. DO UPDATE still doesn't work, for lack of a way of
enforcing uniqueness across partitions, but we can still allow this
case.

Amit Langote, per discussion with Peter Geoghegan.  Additional
wordsmithing by me.

Discussion: http://postgr.es/m/CAA-aLv7Z4uygtq-Q5CvDi9Y=VZxUyEnuWjL=EwCfOof=L04hgg@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ddl.sgml modified +6 −2
src/backend/parser/analyze.c modified +0 −8
src/test/regress/expected/insert_conflict.out modified +10 −0
src/test/regress/sql/insert_conflict.sql modified +10 −0

Documentation touched

Discussion