Horton

Re: unique indexes on partitioned tables

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-01-05T22:12:42Z
Lists: pgsql-hackers

Attachments

This new version fixes markup mistakes in the docs, and nothing else.
I'm not posting the ON CONFLICT DO UPDATE patch from Amit, since I
haven't fixed it; the 0003 patch has been squashed on 0002 instead, with
regression tests adapted.  I'll see about the ON CONFLICT stuff as I
have time.

The 0001 patch is the same I posted last time in the other thread.

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

Commits

  1. Avoid having two PKs in a partition

  2. Allow UNIQUE indexes on partitioned tables