Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS

> On May 22, 2023, at 1:02 AM, Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> wrote:
>
> Hello!
> The following limitations apply to partitioned tables:
>     •
> To create a unique or primary key constraint on a partitioned table, the partition keys must not include any
expressionsor function calls and the constraint's columns must include all of the partition key columns. 

Your choices:

1) Deal with reality: have placedon as part of the primary key
2) don't partition on it, index placedon
3) don't partition on it, index (brandid, playerid, placedon)