hard20 pts · first answer countspartitioningpostgresql

Unique email on a partitioned table

A PostgreSQL users table is hash partitioned by id. You try to add UNIQUE (email) and get an error. Why?

A.Unique constraints on partitioned tables must include all partition key columns, because each partition enforces uniqueness only locallyB.Partitioned tables cannot have any indexesC.Email columns cannot be unique in PostgreSQLD.Hash partitioning only allows integer columns

← Online schema change tools for MySQL Deleting old data every month →