Re: How to attach partition with primary key

2024-06-18 Thread Philipp Faster
03" add primary key (id, "createdAt"); create unique index "Transactions_202403_id_createdAt_idx" on "Transactions_202403" (id desc, "createdAt" desc); alter table "Transactions" attach partition "Transactions_202403" for values from

How to attach partition with primary key

2024-06-17 Thread Philipp Faster
Hello everyone! Using Postgres v15.5. I'm struggling to attach a partition to a table with a primary key. I have a partitioned table `Transactions`: ``` create table "Transactions" ( id bigserial not null, uid uuid