当前仓库属于关闭状态,部分功能使用受限,详情请查阅 仓库状态说明
521 Star 1K Fork 700

龙影 / ECP
关闭

 / 详情

sql文件89处报错。重点最后两行

待办的
创建于  
2015-09-22 16:41

[Err] [Row1] [Imp] ERROR: value too long for type character varying(255)

[Err] [Row1] [Imp] INSERT INTO "public"."ecp" ("--") VALUES (');');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('ALTER TABLE public.sso_parame OWNER TO postgres;');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: TABLE sso_parame; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON TABLE sso_parame IS ''参数'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.id; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.id IS ''id'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.company_id; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.company_id IS ''企业id'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.parent_id; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.parent_id IS ''父类id'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.name; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.name IS ''名称'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.sort_num; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.sort_num IS ''顺序号'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.is_end; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.is_end IS ''终态'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.type; Type: COMMENT; Schema: public; Owner: postgres');INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('COMMENT ON COLUMN sso_parame.type IS ''类别'';');INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES (NULL);INSERT INTO "public"."ecp" ("--") VALUES ('--');INSERT INTO "public"."ecp" ("--") VALUES ('-- Name: COLUMN sso_parame.descriptio

[Msg] [Imp] Processed:6697, Added:6608, Updated:0, Deleted:0, Errors:89
[Msg] [Imp] Finished - Unsuccessfully

评论 (2)

请问你是用什么版本的postgresql?

看你贴的异常 应该是插入的字符串过长导致的错误。
第二个错误是不是你使用了"--"这种特殊字符导致的?我没用过这个数据库

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(3)
5147 loyin 1578914312 411383 hhzgl 1578923053 101186 iceman123 1682996050
Java
1
https://gitee.com/loyin/ECP.git
git@gitee.com:loyin/ECP.git
loyin
ECP
ECP

搜索帮助