db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

PK rules

A primary key or unique constraint on a partitioned table must include every partition key column. Postgres cannot enforce uniqueness across partitions otherwise.

task

Create a range-partitioned table with PRIMARY KEY (id) only and read the error; then create one that works.

hints