economic_crime/docs/20260805_fix_employee_sequence.sql

-- 修复 t_employee 主键序列：避免新增员工时 employee_id 与已有记录冲突

SELECT setval(
  pg_get_serial_sequence('t_employee', 'employee_id'),
  COALESCE((SELECT MAX(employee_id) FROM t_employee), 0) + 1,
  false
);

-- 兼容 Kingbase/PostgreSQL 命名序列
DO $$
BEGIN
    IF EXISTS (
        SELECT 1 FROM pg_class c
        JOIN pg_namespace n ON n.oid = c.relnamespace
        WHERE c.relkind = 'S' AND c.relname = 't_employee_employee_id_seq'
    ) THEN
        PERFORM setval(
            't_employee_employee_id_seq',
            (SELECT COALESCE(MAX(employee_id), 0) + 1 FROM t_employee),
            false
        );
    END IF;
END $$;