Limitations of Partitioned Tables on Greenplum Database

Post date: Nov 27, 2013 2:33:7 AM

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.