CodeFirst.InitTables()创建pgsql的表时报重复异常 返回
SqlSugar
沟通中
2
256
mghcool 发布于1个月前
悬赏:0 飞吻
数据表配置:
[SugarTable("sys.sys_log")]在使用CodeFirst.InitTables() 创建上述表时,检查表是否存在和创建表的逻辑不一致,导致了重复创建。
sql日志如下
15:41:28:771 sql log ========================================================================
15:41:28:771 SELECT 1 FROM pg_catalog.pg_tables
15:41:28:771 WHERE schemaname = 'public'
15:41:28:771 AND Lower(tablename) = 'sys.sys_log'
15:41:28:771 sql log ========================================================================
15:41:28:771 CREATE TABLE "sys"."sys_log"(
15:41:28:771 "id" int8 NOT NULL ,
15:41:28:771 "apiurl" varchar(500) NOT NULL ,
15:41:28:771 "controllername" varchar(20) NOT NULL ,
15:41:28:771 "controllerdesc" varchar(30) NOT NULL ,
15:41:28:771 "actionname" varchar(20) NOT NULL ,
15:41:28:771 "actiondesc" varchar(30) NOT NULL ,
15:41:28:771 "requesttype" varchar(10) NOT NULL ,
15:41:28:771 "requestdata" text NOT NULL ,
15:41:28:771 "responsedata" text NOT NULL ,
15:41:28:771 "issuccess" boolean NOT NULL ,
15:41:28:771 "clienttype" varchar(20) NOT NULL ,
15:41:28:771 "clientip" varchar(30) NOT NULL ,
15:41:28:771 "createuser" varchar(20) NOT NULL ,
15:41:28:771 "createtime" timestamp(3) DEFAULT NULL ,
15:41:28:771 "updateuser" varchar(20) NOT NULL ,
15:41:28:771 "updatetime" timestamp(3) DEFAULT NULL , Primary key("id"))
15:41:28:771 引发的异常:“SqlSugar.SqlSugarException”(位于 SqlSugar.dll 中)
15:41:28:771 “SqlSugar.SqlSugarException”类型的未经处理的异常在 SqlSugar.dll 中发生
15:41:28:771 42P07: relation "sys_log" already exists可以看到在检查表时用的是默认 public 模式,而我要创建的表是 sys 模式下的 sys_log表
热忱回答(2)
-
fate sta VIP0
2周前Pgsql模式是字符串上配的
0 回复 -
fate sta VIP0
2周前sugartable不需要加sys.
0 回复