granicus.if.org Git - postgresql/commit

author	Alvaro Herrera <alvherre@alvh.no-ip.org>
	Mon, 26 Mar 2018 13:43:54 +0000 (10:43 -0300)
committer	Alvaro Herrera <alvherre@alvh.no-ip.org>
	Mon, 26 Mar 2018 13:43:54 +0000 (10:43 -0300)
commit	555ee77a9668e3f1b03307055b5027e13bf1a715
tree	e024aef2f35c73208a7e5f11822d89d97548c6c1	tree \| snapshot
parent	1b89c2188bd38eac68251f16051859996128f2d0	commit \| diff

Handle INSERT .. ON CONFLICT with partitioned tables

Commit eb7ed3f30634 enabled unique constraints on partitioned tables,
but one thing that was not working properly is INSERT/ON CONFLICT.
This commit introduces a new node keeps state related to the ON CONFLICT
clause per partition, and fills it when that partition is about to be
used for tuple routing.

Author: Amit Langote, Álvaro Herrera
Reviewed-by: Etsuro Fujita, Pavan Deolasee
Discussion: https://postgr.es/m/20180228004602.cwdyralmg5ejdqkq@alvherre.pgsql

doc/src/sgml/ddl.sgml		diff \| blob \| history
doc/src/sgml/ref/insert.sgml		diff \| blob \| history
src/backend/catalog/partition.c		diff \| blob \| history
src/backend/executor/execMain.c		diff \| blob \| history
src/backend/executor/execPartition.c		diff \| blob \| history
src/backend/executor/nodeModifyTable.c		diff \| blob \| history
src/backend/parser/analyze.c		diff \| blob \| history
src/include/catalog/partition.h		diff \| blob \| history
src/include/nodes/execnodes.h		diff \| blob \| history
src/include/nodes/nodes.h		diff \| blob \| history
src/test/regress/expected/insert_conflict.out		diff \| blob \| history
src/test/regress/expected/triggers.out		diff \| blob \| history
src/test/regress/sql/insert_conflict.sql		diff \| blob \| history
src/test/regress/sql/triggers.sql		diff \| blob \| history