如何捕获在大容量插入中导致错误的特定ID

import psycopg2

def insert_data(data_list):
    conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpass", host="yourhost", port="yourport")
    try:
        with conn.cursor() as cur:
            for data in data_list:
                try:
                    cur.execute("INSERT INTO your_table (id, value) VALUES (%s, %s)", (data['id'], data['value']))
                except psycopg2.IntegrityError as e:
                    print(f"Error inserting ID {data['id']}: {e}")
        conn.commit()
    except Exception as e:
        print(f"Transaction failed: {e}")
        conn.rollback()
    finally:
        conn.close()

# Example usage
data_list = [
    {'id': 1, 'value': 'A'},
    {'id': 2, 'value': 'B'},
    {'id': 3, 'value': 'C'}
]
insert_data(data_list)

import logging

logging.basicConfig(filename='insert_log.log', level=logging.ERROR)

def insert_data_with_logging(data_list):
    conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpass", host="yourhost", port="yourport")
    try:
        with conn.cursor() as cur:
            for data in data_list:
                try:
                    cur.execute("INSERT INTO your_table (id, value) VALUES (%s, %s)", (data['id'], data['value']))
                except psycopg2.IntegrityError as e:
                    logging.error(f"Error inserting ID {data['id']}: {e}")
        conn.commit()
    except Exception as e:
        logging.error(f"Transaction failed: {e}")
        conn.rollback()
    finally:
        conn.close()

# Example usage
data_list = [
    {'id': 1, 'value': 'A'},
    {'id': 2, 'value': 'B'},
    {'id': 3, 'value': 'C'}
]
insert_data_with_logging(data_list)