Score
0
Watch 519 Star 976 Fork 682

龙影 / ECPJava

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

Open
iceman  Opened this issue

[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

5147 loyin 1578914312 411383 hhzgl 1578923053 101186 iceman123 1578917513 total 3 participants

Comments (2)

5147 loyin 1578914312
龙影 2015-10-10 08:55 owner

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

411383 hhzgl 1578923053
誓言之印 2015-10-10 09:01

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

Sign in to comment

Assignees
Labels
Not set
Projects
Milestones
Branches
Planed to start
Not set
Planed to end
Not set
Top level
Priority