Limitations of Partitioned Tables on Greenplum Database

posted Apr 28, 2017, 3:50 PM by Sachchida Ojha
A primary key or unique constraint on a partitioned table must contain all the partitioning columns. A unique index can omit the partitioning columns; however, it is enforced only on the parts of the partitioned table, not on the partitioned table as a whole.