如何从psycopg2事务中的错误中恢复？

import psycopg2

try:
    # 连接到数据库
    connection = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")
    
    # 创建一个游标对象
    cursor = connection.cursor()
    
    # 开始事务
    connection.begin()
    
    # 执行数据库操作
    cursor.execute("INSERT INTO your_table (column1, column2) VALUES (%s, %s)", (value1, value2))
    
    # 提交事务
    connection.commit()
    
except (psycopg2.DatabaseError, psycopg2.Error) as error:
    # 回滚事务
    connection.rollback()
    
    # 处理错误
    print("Error occurred:", error)
    
finally:
    # 关闭游标和连接
    cursor.close()
    connection.close()