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 参考操作
需要勾选选项“遇到错误继续”