Horton

Allow UNIQUE indexes on partitioned tables

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

View on postgr.es
Commit: eb7ed3f3063401496e4aa4bd68fa33f0be31a72f
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2018-02-19T20:40:00Z
Releases: 11.0 
Allow UNIQUE indexes on partitioned tables

If we restrict unique constraints on partitioned tables so that they
must always include the partition key, then our standard approach to
unique indexes already works --- each unique key is forced to exist
within a single partition, so enforcing the unique restriction in each
index individually is enough to have it enforced globally.  Therefore we
can implement unique indexes on partitions by simply removing a few
restrictions (and adding others.)

Discussion: https://postgr.es/m/20171222212921.hi6hg6pem2w2t36z@alvherre.pgsql
Discussion: https://postgr.es/m/20171229230607.3iib6b62fn3uaf47@alvherre.pgsql
Reviewed-by: Simon Riggs, Jesper Pedersen, Peter Eisentraut, Jaime
	Casanova, Amit Langote

Files

PathChange+/−
doc/src/sgml/ddl.sgml modified +4 −5
doc/src/sgml/ref/alter_table.sgml modified +11 −4
doc/src/sgml/ref/create_index.sgml modified +5 −0
doc/src/sgml/ref/create_table.sgml modified +16 −2
src/backend/bootstrap/bootparse.y modified +2 −0
src/backend/catalog/index.c modified +45 −5
src/backend/catalog/pg_constraint.c modified +76 −0
src/backend/catalog/toasting.c modified +2 −2
src/backend/commands/indexcmds.c modified +113 −12
src/backend/commands/tablecmds.c modified +69 −2
src/backend/parser/analyze.c modified +7 −0
src/backend/parser/parse_utilcmd.c modified +5 −26
src/backend/tcop/utility.c modified +1 −0
src/bin/pg_dump/t/002_pg_dump.pl modified +65 −0
src/include/catalog/index.h modified +4 −1
src/include/catalog/pg_constraint_fn.h modified +3 −1
src/include/commands/defrem.h modified +1 −0
src/include/parser/parse_utilcmd.h modified +2 −1
src/test/regress/expected/alter_table.out modified +0 −8
src/test/regress/expected/create_index.out modified +6 −0
src/test/regress/expected/create_table.out modified +0 −12
src/test/regress/expected/indexing.out modified +292 −2
src/test/regress/expected/insert_conflict.out modified +1 −1
src/test/regress/sql/alter_table.sql modified +0 −2
src/test/regress/sql/create_index.sql modified +6 −0
src/test/regress/sql/create_table.sql modified +0 −8
src/test/regress/sql/indexing.sql modified +171 −1

Documentation touched

Discussion