如何在psycopg2.execute_values或execute_many上仅回滚失败的条目？

import psycopg2

def insert_data(data):
    conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")
    cursor = conn.cursor()

    try:
        psycopg2.extras.execute_values(cursor, "INSERT INTO your_table (column1, column2) VALUES %s", data)
        conn.commit()
    except psycopg2.Error as e:
        failed_rows = e.diag.message_detail  # 获取失败的条目信息
        conn.rollback()  # 回滚事务

        # 重新执行仅包含失败条目的SQL语句
        for row in failed_rows:
            psycopg2.extras.execute_values(cursor, "INSERT INTO your_table (column1, column2) VALUES %s", [row])
            conn.commit()

    cursor.close()
    conn.close()