CREATE SEQUENCE t_pipeline_order_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE;
alter table t_pipeline_gis alter column order_id set default nextval(‘t_pipeline_order_id_seq’);
select setval(‘t_pipeline_order_id_seq’,(select max(order_id) from t_pipeline_gis));