问PostgreSQL声明式分区-对分区表的唯一约束必须包括所有分区列

EN

CREATE TABLE test2 (
    id serial NOT NULL,
    category integer NOT NULL,
    time timestamp(6) NOT NULL,
    prev_event integer,
    next_event integer

) PARTITION BY HASH (category);

alter table test2 add primary key (id);
ERROR:  unique constraint on partitioned table must include all partitioning columns
DETAIL:  PRIMARY KEY constraint on table "test2" lacks column "category" which is part of the partition key.

alter table test2 add primary key (id, category);

alter table test2 add foreign key (prev_event) references test2 (id) on update cascade on delete cascade;
ERROR:  there is no unique constraint matching given keys for referenced table "test2"