pgsql: Check equality semantics for unique indexes on partitioned table

2020-04-01 Thread Tom Lane
Check equality semantics for unique indexes on partitioned tables. We require the partition key to be a subset of the set of columns being made unique, so that physically-separate indexes on the different partitions are sufficient to enforce the uniqueness constraint. The existing code checked th

pgsql: Check equality semantics for unique indexes on partitioned table

2020-04-01 Thread Tom Lane
Check equality semantics for unique indexes on partitioned tables. We require the partition key to be a subset of the set of columns being made unique, so that physically-separate indexes on the different partitions are sufficient to enforce the uniqueness constraint. The existing code checked th

pgsql: Check equality semantics for unique indexes on partitioned table

2020-04-01 Thread Tom Lane
Check equality semantics for unique indexes on partitioned tables. We require the partition key to be a subset of the set of columns being made unique, so that physically-separate indexes on the different partitions are sufficient to enforce the uniqueness constraint. The existing code checked th