pgsql: Foreign keys on partitioned tables

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Foreign keys on partitioned tables
Date: 2018-04-04 17:03:30
Message-ID: E1f3loo-0005t4-P8@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Foreign keys on partitioned tables

Author: Álvaro Herrera
Discussion: https://postgr.es/m/20171231194359.cvojcour423ulha4@alvherre.pgsql
Reviewed-by: Peter Eisentraut

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3de241dba86f3dd000434f70aebba725fb928032

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 3 +-
doc/src/sgml/ref/create_table.sgml | 13 +-
src/backend/catalog/pg_constraint.c | 237 +++++++++++++++++++++++++++++
src/backend/commands/tablecmds.c | 193 ++++++++++++++++++-----
src/backend/parser/parse_utilcmd.c | 12 --
src/backend/utils/adt/ri_triggers.c | 59 ++++---
src/bin/pg_dump/pg_dump.c | 42 +++--
src/include/catalog/pg_constraint_fn.h | 16 ++
src/include/commands/tablecmds.h | 4 +
src/test/regress/expected/alter_table.out | 4 -
src/test/regress/expected/create_table.out | 10 --
src/test/regress/expected/foreign_key.out | 211 +++++++++++++++++++++++++
src/test/regress/expected/inherit.out | 25 +++
src/test/regress/sql/alter_table.sql | 1 -
src/test/regress/sql/create_table.sql | 8 -
src/test/regress/sql/foreign_key.sql | 154 +++++++++++++++++++
src/test/regress/sql/inherit.sql | 12 ++
17 files changed, 895 insertions(+), 109 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2018-04-04 17:10:46 Re: pgsql: New files for MERGE
Previous Message Teodor Sigaev 2018-04-04 16:29:53 pgsql: Skip full index scan during cleanup of B-tree indexes when possi

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2018-04-04 17:07:08 Re: Add support for printing/reading MergeAction nodes
Previous Message Simon Riggs 2018-04-04 16:57:39 Re: Add support for printing/reading MergeAction nodes