pg建唯一约束报错

1、问题描述

pg数据库增加唯一约束报错

数据表如下

CREATE TABLE "dquality_ycbf"."test1" (
  id serial primary key,
  "rq" date,
  "sfjjr" varchar(2) COLLATE "pg_catalog"."default"
)
;

建唯一约束

ALTER TABLE dquality_ycbf.test1 ADD UNIQUE (rq);
 

执行语句报错：UNIQUE index must contain all columns in the distribution key of relation "test1"

2、解决。

把表修改成复制表，然后增加唯一约束

    alter table dquality_ycbf.test1 set Distributed REPLICATED;
    
ALTER TABLE dquality_ycbf.test1 ADD UNIQUE (rq);