Re: Partitioning on the date part of a timestamp & PK issues - Mailing list pgsql-admin

You are indirectly hitting the documented limitation that:

"Unique constraints (and hence primary keys) on partitioned tables must include all the partition key columns. This limitation exists because the individual indexes making up the constraint can only directly enforce uniqueness within their own partitions; therefore, the partition structure itself must guarantee that there are not duplicates in different partitions."

So if you want to enforce PKs here you need to both add the physical column to the table AND add the same to your primary key.

David J.