> On May 22, 2023, at 1:02 AM, Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx> 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)
