环境运维

mysql导入到pgsql出现了索引已经存在的错误

[DTF] 63> sys_dict: Create index "uk_sd_dict_code"

[ERR] 99> CREATE INDEX "uk_sd_dict_code" ON "public"."sys_dict" USING btree (

  "dict_code"

)

[ERR] 99> ERROR:  relation "uk_sd_dict_code" already exists

 

[DTF] 64> sys_dict_item: Create index "idx_sdi_role_dict_id"

[ERR] 99> CREATE INDEX "idx_sdi_role_dict_id" ON "public"."sys_dict_item" USING btree (

  "dict_id"

)

[ERR] 99> ERROR:  relation "idx_sdi_role_dict_id" already exists

 

[DTF] 64> sys_dict_item: Create index "idx_sdi_role_sort_order"

[ERR] 99> CREATE INDEX "idx_sdi_role_sort_order" ON "public"."sys_dict_item" USING btree (

  "sort_order"

)

[ERR] 99> ERROR:  relation "idx_sdi_role_sort_order" already exists

 

[DTF] 64> sys_dict_item: Create index "idx_sdi_status"

[ERR] 99> CREATE INDEX "idx_sdi_status" ON "public"."sys_dict_item" USING btree (

  "status"

)

[ERR] 99> ERROR:  relation "idx_sdi_status" already exists

 

[DTF] 64> sys_dict_item: Create index "idx_sdi_dict_val"

[ERR] 99> CREATE INDEX "idx_sdi_dict_val" ON "public"."sys_dict_item" USING btree (

  "dict_id",

  "item_value"

)

[ERR] 99> ERROR:  relation "idx_sdi_dict_val" already exists

 

https://blog.csdn.net/wtf_awsl/article/details/124668348 参考操作

需要勾选选项“遇到错误继续”