-- 修改现有列ALTER TABLE public.mis_action_log 
ALTER COLUMN id SET DATA TYPE BIGSERIAL;

-- 修改现有列ALTER TABLE public.mis_action_log 
ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY;

SELECT MAX(id) FROM public.mis_action_log;

ALTER SEQUENCE mis_action_log_id_seq RESTART WITH [最大ID值+1];

ALTER TABLE public.mis_action_log 
ALTER COLUMN id RESTART WITH [最大ID值+1];

DO $$DECLARE
    max_id bigint;BEGIN
    SELECT COALESCE(MAX(id), 0) INTO max_id FROM public.mis_action_log;
    EXECUTE format('ALTER SEQUENCE mis_action_log_id_seq RESTART WITH %s', max_id + 1);END $$;

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE TABLE users (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    name VARCHAR(100)
);

-- 查看序列当前值SELECT last_value FROM mis_action_log_id_seq;-- 测试插入(不指定ID)INSERT INTO public.mis_action_log(source_sort) VALUES('test') RETURNING id;-- 检查序列下一个值SELECT nextval('mis_action_log_id_seq');

-- 1. 添加自增功能(选择一种方法)ALTER TABLE public.mis_action_log 
ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY;-- 2. 设置从最大ID+1开始DO $$DECLARE
    max_id bigint;BEGIN
    SELECT COALESCE(MAX(id), 0) INTO max_id FROM public.mis_action_log;
    EXECUTE format('ALTER TABLE public.mis_action_log ALTER COLUMN id RESTART WITH %s', max_id + 1);END $$;-- 3. 验证INSERT INTO public.mis_action_log(source_sort) VALUES('验证插入') RETURNING id;