Horton

Support foreign keys that reference partitioned tables

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

View on postgr.es
Commit: f56f8f8da6afd8523b4d5284e02a20ed2b33ef8d
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2019-04-03T17:40:21Z
Releases: 12.0 
Support foreign keys that reference partitioned tables

Previously, while primary keys could be made on partitioned tables, it
was not possible to define foreign keys that reference those primary
keys.  Now it is possible to do that.

Author: Álvaro Herrera
Reviewed-by: Amit Langote, Jesper Pedersen
Discussion: https://postgr.es/m/20181102234158.735b3fevta63msbj@alvherre.pgsql

Files

PathChange+/−
doc/src/sgml/ref/create_table.sgml modified +1 −6
src/backend/commands/tablecmds.c modified +965 −377
src/backend/utils/adt/ri_triggers.c modified +248 −15
src/backend/utils/adt/ruleutils.c modified +18 −0
src/bin/psql/describe.c modified +5 −2
src/include/commands/tablecmds.h modified +0 −4
src/include/commands/trigger.h modified +2 −0
src/include/utils/ruleutils.h modified +1 −0
src/test/isolation/expected/fk-partitioned-1.out added +133 −0
src/test/isolation/expected/fk-partitioned-2.out added +70 −0
src/test/isolation/isolation_schedule modified +2 −0
src/test/isolation/specs/fk-partitioned-1.spec added +45 −0
src/test/isolation/specs/fk-partitioned-2.spec added +29 −0
src/test/regress/expected/foreign_key.out modified +319 −15
src/test/regress/sql/foreign_key.sql modified +201 −12

Documentation touched

Discussion