—神通建表语句:
CREATE TABLE “RECORD_PROCESS”
(
“ID” VARCHAR(255) NOT NULL,
“FLOW_CODE” VARCHAR(255) NULL,
“PROCESSSTART” TIMESTAMP DEFAULT (NOW())::timestamp(6) without time zone NULL,
“PROCESSSORT” VARCHAR(255) NULL
)
直接基于DTS迁移会报错,其中TIMESTAMP DEFAULT (NOW())::timestamp(6) without time zone语法为PG的,这块DM跟PG的存在差异,需做调整
可将TIMESTAMP DEFAULT (NOW())::timestamp(6) without time zone 调整为TIMESTAMP without time zone DEFAULT (NOW())::timestamp(6)
调整后的语句执行可成功:
CREATE TABLE “RECORD_PROCESS”
(
“ID” VARCHAR(255) NOT NULL,
“FLOW_CODE” VARCHAR(255) NULL,
“PROCESSEND” TIMESTAMP without time zone DEFAULT (NOW())::timestamp(6) NULL,
“PROCESSSORT” VARCHAR(255) NULL
);
此外TIMESTAMP DEFAULT (‘NOW’)::timestamp(3) with time zone这类可调整成TIMESTAMP with time zone DEFAULT (NOW())::timestamp(3)。
文章
阅读量
获赞