Horton

Re: unique indexes on partitioned tables

Jesper Pedersen <jesper.pedersen@redhat.com>

View thread View on postgr.es
From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-01-25T16:12:31Z
Lists: pgsql-hackers 
Hi Alvaro,

On 01/22/2018 05:55 PM, Alvaro Herrera wrote:
> Alvaro Herrera wrote:
>> Version 4 of this patch, rebased on today's master.
> 
> 

Passes make check-world.

Maybe add a test case to indexing.sql that highlights that hash indexes 
doesn't support UNIQUE; although not unique to partitioned indexes.

Thanks for working on this !

Best regards,
  Jesper

Commits

  1. Avoid having two PKs in a partition

  2. Allow UNIQUE indexes on partitioned tables