且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用liquibase标签将最大列值设置为序列起始值

更新时间:2023-02-07 14:02:44

因此,这样的解决方案对我有用:

So, such a solution worked for me:

<changeSet author="dfche" id="1448634241199-1"> 
  <createSequence sequenceName="user_id_seq" startValue="1" incrementBy="1"/> 
</changeSet> 
<changeSet author="dfche" id="1448634241199-2">
  <sql dbms="postgresql">select setval('user_id_seq', max(id)+1) from jhi_user</sql> 
  <sql dbms="h2">alter sequence user_id_seq restart with (select max(id)+1 from jhi_user)</sql>
</changeSet>