插入数据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 com.sq.platform.basePlatform.dao.VehicleMapper.insertVehicleAppkey-Inline |
03 |
### The error occurred while setting parameters
|
04 |
### SQL: insert into vehicle__appkey(vehicle_id_fk, appkey_id_fk) values (?, ?) |
05 |
### Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "vehicle__appKey_pkey"
|
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"
|
07 |
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java: 239 )
|
08 |
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java: 73 )
|
09 |
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java: 74 )
|
10 |
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java: 399 )
|
11 |
at com.sun.proxy.$Proxy11.insert(Unknown Source)
|
表中 vehicle__appkey id字段如下
1 |
id integer NOT NULL DEFAULT nextval('"vehicle__appKey_id_seq"'::regclass), |
1 |
vehicle__appKey_pkey 序列表如下 |
1 |
<span style= "font-family: Arial, Helvetica, sans-serif;" >-- Sequence: "vehicle__appKey_id_seq" </span>
|
01 |
<pre name= "code" class = "java" >
|
02 |
-- DROP SEQUENCE "vehicle__appKey_id_seq" ;
|
04 |
CREATE SEQUENCE "vehicle__appKey_id_seq"
|
07 |
MAXVALUE 9223372036854775807
|
08 |
<span style= "color:#ff0000;" >START 711 </span>
|
10 |
ALTER TABLE "vehicle__appKey_id_seq"
|
不难看出以上错误是由于
vehicle__appkey中id字段重复导致的,而id字段的值来自于
vehicle__appKey_pkey 序列表,
START 711 标示下一个id值为712,而712的id
vehicle__appkey表中已经存在了,所以插入数据时报以上这个错误
解决方法:将"vehicle__appKey_id_seq"中的当前值设为为vehicle__appkey id的最大值