> On May 22, 2023, at 1:02 AM, Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)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 expressions or 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)