Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "

概述插入数据postgre 报错如下 01 ### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "vehicle__appKey_pkey" 02 ### The error may involve co

插入数据postgre 报错如下

@H_419_4@ 01 ### Error updating database. Cause: org.postgresql.util.PsqlException: ERROR: duplicate key value violates unique constraint "vehicle__appKey_pkey" @H_419_4@ 02 ### The error may involve com.sq.platform.basePlatform.dao.VehicleMapper.insertVehicleAppkey-Inline @H_419_4@ 03 ### The error occurred while setting parameters @H_419_4@ 04 ### sql: insert into vehicle__appkey(vehicle_ID_fk,appkey_ID_fk) values (?,?) @H_419_4@ 05 ### Cause: org.postgresql.util.PsqlException: ERROR: duplicate key value violates unique constraint "vehicle__appKey_pkey" @H_419_4@ 06 ; sql []; ERROR: duplicate key value violates unique constraint "vehicle__appKey_pkey"; nested exception is org.postgresql.util.PsqlException: ERROR: duplicate key value violates unique constraint "vehicle__appKey_pkey" @H_419_4@ 07 at org.springframework.jdbc.support.sqlErrorCodesqlExceptionTranslator.doTranslate(sqlErrorCodesqlExceptionTranslator.java:239) @H_419_4@ 08 at org.springframework.jdbc.support.AbstractFallbacksqlExceptionTranslator.translate(AbstractFallbacksqlExceptionTranslator.java:73) @H_419_4@ 09 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74) @H_419_4@ 10 at org.mybatis.spring.sqlSessionTemplate$sqlSessionInterceptor.invoke(sqlSessionTemplate.java:399) @H_419_4@ 11 at com.sun.proxy.$Proxy11.insert(UnkNown Source)

表中 vehicle__appkey ID字段如下

@H_419_4@ 1 ID integer NOT NulL DEFAulT nextval('"vehicle__appKey_ID_seq"'::regclass), @H_419_4@ 1 @H_419_4@ 1 @H_419_4@ 1 vehicle__appKey_pkey 序列表如下 @H_419_4@ 1 <span style="Font-family: Arial,Helvetica,sans-serif;">-- Sequence: "vehicle__appKey_ID_seq"</span> @H_419_4@ 01 <pre name="code" class="java"> @H_419_4@ 02 -- DROP SEQUENCE "vehicle__appKey_ID_seq"; @H_419_4@ 03 @H_419_4@ 04 CREATE SEQUENCE "vehicle__appKey_ID_seq" @H_419_4@ 05 INCREMENT 1 @H_419_4@ 06 MINVALUE 1 @H_419_4@ 07 MAXVALUE 9223372036854775807 @H_419_4@ 08 <span style="color:#ff0000;">START 711</span> @H_419_4@ 09 CACHE 1; @H_419_4@ 10 ALTER table "vehicle__appKey_ID_seq" @H_419_4@ 11 OWNER TO postgres;

不难看出以上错误是由于 vehicle__appkey中ID字段重复导致的，而ID字段的值来自于 vehicle__appKey_pkey 序列表， START 711 标示下一个ID值为712，而712的ID vehicle__appkey表中已经存在了，所以插入数据时报以上这个错误

解决方法：将"vehicle__appKey_ID_seq"中的当前值设为为vehicle__appkey ID的最大值

总结

以上是内存溢出为你收集整理的Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "全部内容，希望文章能够帮你解决Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。