> On Sep 27, 2024, at 21:25, Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> wrote: > > Can't we use primary key on singal column(betid) on partitioned table rather than using composite key (placedon,betid)? No. Any unique constraint on a partitioned table must include the partition key, including a primary key constraint.
