On Friday, September 27, 2024, Durgamahesh Manne <maheshpostgr...@gmail.com> wrote:
> > ERROR: unique constraint on partitioned table must include all > partitioning columns > DETAIL: PRIMARY KEY constraint on table "bet" lacks column "placedon" > which is part of the partition key. > test=> > > Can't we use primary key on singal column(betid) on partitioned table > rather than using composite key (placedon,betid)? > No. It would be misleading to allow such a thing because a unique index can only span a single partition. David J.
