创建sequence

create sequence global_version_seq increment by 1 minvalue 1 no maxvalue start with 1;

创建version字段

create table {
version bigint not null default nextval('global_version_seq ')
}

更新数据

update table set col=val, version = nextval('global_version_seq ') where version = previous_version…