Horton

Fix unique INCLUDE indexes on partitioned tables

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 0ad41cf537ea5f076273fcffa4c83a184bd9910f
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2019-01-14T22:28:10Z
Releases: 12.0 
Fix unique INCLUDE indexes on partitioned tables

We were considering the INCLUDE columns as part of the key, allowing
unicity-violating rows to be inserted in different partitions.

Concurrent development conflict in eb7ed3f30634 and 8224de4f42cc.

Reported-by: Justin Pryzby
Discussion: https://postgr.es/m/20190109065109.GA4285@telsasoft.com

Files

PathChange+/−
src/backend/commands/indexcmds.c modified +1 −1
src/test/regress/expected/indexing.out modified +3 −0
src/test/regress/sql/indexing.sql modified +1 −0

Discussion