在PostgreSQL 13+中有一个内置的gen_random_uuid()。在旧版本中，uuid-ossp扩展提供uuid_generate_v4()。您可以直接在insert语句中使用它们，而不是要替换的id：

INSERT INTO timeline_event 
VALUES (
    gen_random_uuid(),
    '2022-09-07 10:08:55.048',
    NULL,
    0,
    '2022-09-07 10:08:55.048',
    0,
    1,
    false,
    NULL,
    'CONFIGURATION',
    NULL,
    NULL,
    'f691d7c9-18a3-4c32-bd25-876f6e4ec19f'::uuid,
    'd1ac2ff7-01a6-4f5f-b1fe-d823253d2fa8'::uuid,
    '03000337-1918-4277-aeef-cc9b3bca543f'::uuid,
    '4c6a3248-f14b-4653-9627-47c15cec503d'::uuid )
returning *;

您甚至可以将它们添加到on conflict子句的语句末尾，以便在发生冲突时触发（只要id列具有unique约束）：demo

INSERT INTO timeline_event 
VALUES (
    '2e1c5231-ba19-4c27-bedc-bef6c4066d75'::uuid,
    '2022-09-07 10:08:55.048',
    NULL,
    0,
    '2022-09-07 10:08:55.048',
    0,
    1,
    false,
    NULL,
    'CONFIGURATION',
    NULL,
    NULL,
    'f691d7c9-18a3-4c32-bd25-876f6e4ec19f'::uuid,
    'd1ac2ff7-01a6-4f5f-b1fe-d823253d2fa8'::uuid,
    '03000337-1918-4277-aeef-cc9b3bca543f'::uuid,
    '4c6a3248-f14b-4653-9627-47c15cec503d'::uuid )
on conflict (id) do update set id=gen_random_uuid() --this
returning *;