注册

对象[id]DEFAULT约束表达式无效

Miles 2023/06/14 1312 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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

)

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