On Sat, Sep 28, 2024 at 12:39 AM David G. Johnston < david.g.johns...@gmail.com> wrote:
> 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. > That is IMO a serious (and probably unfixable, given how PG stores tables) flaw in PG's partitioning design. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> crustacean!
