注册

PG数据库迁移DM数据库报错对象[id]DEFAULT约束表达式无效,部分成功部分失败,是因为序列包含中文了吗?

2024/07/04 582 1 已解决

能正确实行的SQL:

CREATE TABLE "public"."user_info_tbl" (
 "id" INT DEFAULT "public"."UserInfoTbl_id_seq".nextval NOT NULL,
 "username" VARCHAR ( 32 ) NOT NULL,
 "password" VARCHAR ( 128 ) NOT NULL,
 "privilege" VARCHAR ( 8 ) NOT NULL,
 "login_time" TIMESTAMP ( 6 ) NULL,
 "upd_time" TIMESTAMP ( 6 ) NULL,
 "manager" VARCHAR ( 32 ) NULL,
 "del_flag" VARCHAR ( 1 ) NOT NULL,
 "menu" VARCHAR ( 1024 ) NULL,
 "dept_id" VARCHAR ( 50 ) NULL,
 PRIMARY KEY ( "id" )
);

执行报错的SQL 对象[id]DEFAULT约束表达式无效

CREATE TABLE "public"."non_ag_com_geo_tbl" (
 "id" INT DEFAULT "public"."合并输出 _id_seq".nextval NOT NULL,
 "geom" SYSGEO2.ST_GEOMETRY NULL,
 "city" VARCHAR ( 100 ) NULL,
 "province" VARCHAR ( 100 ) NULL,
 "district" VARCHAR ( 100 ) NULL,
 "version_year" VARCHAR ( 8 ) NULL,
 "del_flag" VARCHAR ( 1 ) NULL,
 "login_time" TIMESTAMP ( 6 ) NULL,
 "upd_time" TIMESTAMP ( 6 ) NULL,
 "manager" VARCHAR ( 32 ) NULL,
 PRIMARY KEY ( "id" ) 
);

序列都在的:
image.png

大佬们,这该如何解决

回答 0
暂无回答
扫一扫
联系客服