duplicate keys detected: '0'. this may cause an update error

-- 假设表名为 'my_table'，主键列为 'id'
SELECT id, COUNT(*)
FROM my_table
GROUP BY id
HAVING COUNT(*) > 1;

DELETE FROM my_table
WHERE id IN (
    SELECT id
    FROM (
        SELECT id
        FROM my_table
        GROUP BY id
        HAVING COUNT(*) > 1
    ) AS duplicates
)
AND ctid NOT IN (
    SELECT MIN(ctid)
    FROM my_table
    GROUP BY id
);

BEGIN;
SELECT * FROM my_table WHERE id = 0 FOR UPDATE;
-- 执行更新操作
UPDATE my_table SET column = 'new_value' WHERE id = 0;
COMMIT;

import pandas as pd

# 假设数据存储在CSV文件中
data = pd.read_csv('data.csv')

# 删除重复的主键值
data = data.drop_duplicates(subset=['id'])

# 导入数据到数据库
data.to_sql('my_table', engine, if_exists='append', index=False)

INSERT INTO my_table (id, column) VALUES (0, 'new_value')
ON CONFLICT (id) DO UPDATE SET column = EXCLUDED.column;