为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win11
【CPU】: i7-10750H
【问题描述】*:我怀疑是序列的问题,但是又不知道从哪里下手。
完整异常信息:
错误号: -2670
错误消息: 第59 行附近出现错误:
对象[id]DEFAULT约束表达式无效
CREATE TABLE "st_houst_prod"."gis_jbnt"
(
"id" INT DEFAULT gis_jbnt_id_seq.nextval
NOT NULL,
"geom" SYSGEO.ST_GEOMETRY NULL,
"objectid" BIGINT NULL,
"bsm" VARCHAR(18) NULL,
"ysdm" VARCHAR(10) NULL,
"yjjbnttbbh" VARCHAR(20) NULL,
"tbbh" VARCHAR(8) NULL,
"dlbm" VARCHAR(5) NULL,
"dlmc" VARCHAR(60) NULL,
"qsxz" VARCHAR(2) NULL,
"qsdwdm" VARCHAR(19) NULL,
"qsdwmc" VARCHAR(255) NULL,
"zldwdm" VARCHAR(19) NULL,
"zldwmc" VARCHAR(255) NULL,
"yjjbnttbmj" FLOAT(17) NULL,
"kcdlbm" VARCHAR(5) NULL,
"kcxs" FLOAT(17) NULL,
"kcmj" FLOAT(17) NULL,
"yjjbntmj" FLOAT(17) NULL,
"gdlx" VARCHAR(2) NULL,
"gdpdjb" VARCHAR(2) NULL,
"ggbzl" VARCHAR(10) NULL,
"tbxhdm" VARCHAR(6) NULL,
"tbxhmc" VARCHAR(20) NULL,
"zzsxdm" VARCHAR(6) NULL,
"zzsxmc" VARCHAR(20) NULL,
"zlfldm" VARCHAR(12) NULL,
"frdbs" VARCHAR(1) NULL,
"sjnf" INT NULL,
"cfzr" VARCHAR(20) NULL,
"zmc" VARCHAR(50) NULL,
"zzrr" VARCHAR(20) NULL,
"zrrmc" VARCHAR(20) NULL,
"lxdh" VARCHAR(20) NULL,
"jzdz" VARCHAR(50) NULL,
"bhkssj" TIMESTAMP(6) NULL,
"bhjssj" TIMESTAMP(6) NULL,
"sjbh" VARCHAR(20) NULL,
"sjmc" VARCHAR(50) NULL,
"zrsyx" VARCHAR(100) NULL,
"bz" VARCHAR(50) NULL,
"zrrzjhm" VARCHAR(18) NULL,
"gddb" INT NULL,
"gddj" INT NULL,
"xzqdm" VARCHAR(12) NULL,
"xzqmc" VARCHAR(100) NULL,
"wdgd" VARCHAR(10) NULL,
"sfwyyjjbnt" VARCHAR(10) NULL,
"fwdgdhrly" VARCHAR(255) NULL,
"yjjbnttbmj_ys" FLOAT(17) NULL,
"yjjbntmj_ys" FLOAT(17) NULL,
"kcmj_ys" FLOAT(17) NULL,
"wdgd_ys" VARCHAR(10) NULL,
"shape_length" FLOAT(17) NULL,
"shape_area" FLOAT(17) NULL
)
检查一下序列gis_jbnt_id_seq它所属的用户是否为st_houst_prod,如果不是则需要指定所属用户
只有序列自增的表有这个问题