On Thu, 2025-10-23 at 13:11 -0700, Jonathan Reis wrote:
> Thank you very much for your recommendations and your sample code. I originally had it your way, but then I found out
thisis not possible
>
> create table message (
> id uuid PRIMARY KEY
> -- ... plus other columns
> ) partition by range (uuid_extract_timestamp(id));
That's because you want to make "id" a primary key, but you can only create a primary
key constraint on a partitioned table if the partitioning key is a subset of the
primary key.
I recommend that you create a primary key on each partition rather than having one
on the partitioned table.
Yours,
Laurenz Albe