pgsql: Foreign keys on partitioned tables - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Foreign keys on partitioned tables
Date
Msg-id E1f3loo-0005t4-P8@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Teodor Sigaev
Date:
Subject: pgsql: Skip full index scan during cleanup of B-tree indexes whenpossi
Next
From: Peter Geoghegan
Date:
Subject: Re: pgsql: Optimize btree insertions for common case of increasing values