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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


> 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)

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux