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 |
Thread: | |
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.)
Thanks
--
Álvaro Herrera https://www.2ndQuadrant.com/
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 |
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 |