-- 修改現(xiàn)有列
ALTER TABLE public.mis_action_log;
ALTER COLUMN id SET DATA TYPE BIGSERIAL;

-- 修改現(xiàn)有列
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)
);

-- 查看序列當(dāng)前值
SELECT last_value FROM mis_action_log_id_seq;

-- 測試插入(不指定ID)
INSERT INTO public.mis_action_log(source_sort) VALUES('test') RETURNING id;

-- 檢查序列下一個(gè)值
SELECT nextval('mis_action_log_id_seq');

-- 1. 添加自增功能(選擇一種方法)
ALTER TABLE public.mis_action_log;
ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY;

-- 2. 設(shè)置從最大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. 驗(yàn)證
INSERT INTO public.mis_action_log(source_sort) VALUES('驗(yàn)證插入') RETURNING id;