unique indexes on partitioned tables

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: unique indexes on partitioned tables
Date: 2017-12-29 23:06:07
Message-ID: 20171229230607.3iib6b62fn3uaf47@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This is the patch series for UNIQUE / PRIMARY KEY indexes on partitioned
tables. This is on top of the patch in
https://postgr.es/m/20171229175930.3aew7lzwd5w6m2x6@alvherre.pgsql
but I included it here as 0001 for simplicity. (Don't review that patch
in this thread please). This is essentially the same patch I posted
elsewhere in that thread.

I included Amit's support for ON CONFLICT DO UPDATE, but as I mentioned
in the other thread, it has a small bug. In principle we could push
0002 together with 0003, but I'd rather fix 0004 first and push it all
as one commit.

This serves as basis to build foreign keys on top; I'll post that
separately.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v1-0001-Local-partitioned-indexes.patch text/plain 153.3 KB
v1-0002-allow-indexes-on-partitioned-tables-to-be-unique.patch text/plain 38.4 KB
v1-0003-on-conflict-do-update-not-supported.patch text/plain 991 bytes
v1-0004-Teach-executor-to-handle-ON-CONFLICT-key-on-parti.patch text/plain 7.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-12-29 23:16:18 Re: Converting plpgsql to use DTYPE_REC for named composite types
Previous Message Alvaro Herrera 2017-12-29 22:53:19 FOR EACH ROW triggers on partitioned tables