有关PGSQL中主键自增长设置

1. 删除主键关联的序列

    DROP sequence "public"."activity_info_id_seq"
   

2. 创建所需序列

   CREATE SEQUENCE activity_info_id_seq
        START WITH 256
        INCREMENT BY 1
        NO MINVALUE
        NO MAXVALUE
        CACHE 1;

3. 修改主键指向新生成序列

   alter table activity_info alter column id set default nextval('activity_info_id_seq');
       
   

转载于:https://my.oschina.net/u/2500808/blog/549506