01
概述
openGauss分区表支持两种索引:全局(global)索引和本地(local)索引。...创建主键约束和唯一约束必须要包含分区字段,创建本地唯一索引也必须要包含分区字段,但是创建全局唯一索引没有这个限制。...into part_index_test select generate_series(1,1000),'1','20210401',generate_series(1,1000);
insert into...select generate_series(1,1000),'1','20210403',generate_series(1,1000);
insert into part_index_test select...generate_series(1,1000),'1','20210404',generate_series(1,1000);
insert into part_index_test select generate_series