Re: Foreign keys and partitioned tables

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Foreign keys and partitioned tables
Date: 2018-01-24 17:52:45
Message-ID: 20180124175245.hsakxldr4cd74svv@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Alvaro Herrera wrote:
> This patch enables foreign key constraints to and from partitioned
> tables.

This version is rebased on current master.

0001: fix for a get_relation_info bug in current master.
Posted in <20180124174134(dot)ma4ui2kczmqwb4um(at)alvherre(dot)pgsql>
0002: Allows local partitioned index to be unique;
Posted in <20180122225559(dot)7pbzomvgp5iwmath(at)alvherre(dot)pgsql>
0003: Allows FOR EACH ROW triggers on partitioned tables;
Posted in <20180123221027(dot)2qenwwpvgplrrx3d(at)alvherre(dot)pgsql>

0004: the actual matter of this thread.
0005: bugfix for 0004, after recent changes I introduced in 0004.
It's separate because I am undecided about it being the best
approach; maybe further changes in 0003 are a better approach.

No further changes from the version I posted upthread. Tests pass. I'm
going to review this code now to see what further changes are needed (at
the very least, I think some dependency changes are in order; plus need
to add a few more tests for various ri_triggers.c code paths.)


Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v2-0001-Ignore-partitioned-indexes-in-get_relation_info.patch text/plain 1.0 KB
v2-0002-allow-indexes-on-partitioned-tables-to-be-unique.patch text/plain 62.7 KB
v2-0003-Allow-FOR-EACH-ROW-triggers-on-partitioned-tables.patch text/plain 32.2 KB
v2-0004-WIP-Allow-foreign-key-triggers-on-partitioned-tab.patch text/plain 38.6 KB
v2-0005-don-t-error-creating-constraint-triggers-if-inter.patch text/plain 1.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2018-01-24 17:57:08 Re: [PROPOSAL] Shared Ispell dictionaries
Previous Message Stephen Frost 2018-01-24 17:43:51 Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WAL files