projects / users / bernd / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9155580) | patch
Support foreign keys that reference partitioned tables
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Wed, 3 Apr 2019 17:38:20 +0000 (14:38 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Wed, 3 Apr 2019 17:40:21 +0000 (14:40 -0300)
commitf56f8f8da6afd8523b4d5284e02a20ed2b33ef8d
treee5f59afa60601ff9c2e92d7746df6dba57b73c99tree
parent9155580fd5fc2a0cbb23376dfca7cd21f59c2c7bcommit | diff
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
15 files changed:
doc/src/sgml/ref/create_table.sgml diff | blob | blame | history
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/utils/adt/ri_triggers.c diff | blob | blame | history
src/backend/utils/adt/ruleutils.c diff | blob | blame | history
src/bin/psql/describe.c diff | blob | blame | history
src/include/commands/tablecmds.h diff | blob | blame | history
src/include/commands/trigger.h diff | blob | blame | history
src/include/utils/ruleutils.h diff | blob | blame | history
src/test/isolation/expected/fk-partitioned-1.out [new file with mode: 0644] blob
src/test/isolation/expected/fk-partitioned-2.out [new file with mode: 0644] blob
src/test/isolation/isolation_schedule diff | blob | blame | history
src/test/isolation/specs/fk-partitioned-1.spec [new file with mode: 0644] blob
src/test/isolation/specs/fk-partitioned-2.spec [new file with mode: 0644] blob
src/test/regress/expected/foreign_key.out diff | blob | blame | history
src/test/regress/sql/foreign_key.sql diff | blob | blame | history
Bernd Helmle's repository