Re: pgsql: Allow UNIQUE indexes on partitioned tables

2018-02-21 Thread David Rowley
On 20 February 2018 at 09:40, Alvaro Herrera wrote: > Modified Files > -- > doc/src/sgml/ddl.sgml | 9 +- Attached is a very small fix to a small error this patch created in the docs. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQ

pgsql: Allow UNIQUE indexes on partitioned tables

2018-02-19 Thread Alvaro Herrera
Allow UNIQUE indexes on partitioned tables If we restrict unique constraints on partitioned tables so that they must always include the partition key, then our standard approach to unique indexes already works --- each unique key is forced to exist within a single partition, so enforcing the uniqu