| 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 |
| 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 |