Re: Regarding use of single column as primary key on partitioned table

On Sat, Sep 28, 2024 at 12:39 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Friday, September 27, 2024, Durgamahesh Manne <
> maheshpostgres9(at)gmail(dot)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!