如果一个字段为真，则自动从数据库中删除对象

-- 示例：创建一个触发器，当字段is_deleted为true时自动删除对象
CREATE TRIGGER delete_object_trigger
AFTER UPDATE ON your_table
FOR EACH ROW
BEGIN
    IF NEW.is_deleted = TRUE THEN
        DELETE FROM your_table WHERE id = NEW.id;
    END IF;
END;

# 示例：Python代码中实现自动删除逻辑
import psycopg2

def delete_object_if_deleted(object_id):
    conn = psycopg2.connect(database="your_db", user="your_user", password="your_password", host="your_host", port="your_port")
    cursor = conn.cursor()
    
    try:
        cursor.execute("SELECT is_deleted FROM your_table WHERE id = %s FOR UPDATE", (object_id,))
        result = cursor.fetchone()
        if result and result[0]:
            cursor.execute("DELETE FROM your_table WHERE id = %s", (object_id,))
            conn.commit()
    except Exception as e:
        conn.rollback()
        print(f"Error: {e}")
    finally:
        cursor.close()
        conn.close()