Index: uc_approve.py
===================================================================
--- uc_approve.py	(revision 527c0976508c7d2fad14e9180bcf1a211d5f18af)
+++ uc_approve.py	(revision 95cf703d2ef8f7abf8a3684935be560cdf73467f)
@@ -1,3 +1,3 @@
-from db import get_connection, get_transaction, pick_from_list, print_table
+from db import get_connection, pick_from_list, print_table
 
 
@@ -120,35 +120,18 @@
 
     new_status = "approved" if action == 0 else "rejected"
+    conn = get_connection()
     try:
-        with get_transaction() as conn:
-            with conn.cursor() as cur:
-                # For approvals, re-check conflicts within the transaction
-                # to prevent approving overlapping reservations
-                if new_status == "approved":
-                    cur.execute(
-                        """
-                        SELECT COUNT(*) FROM reservations
-                        WHERE resource_id = %s
-                          AND reservation_id != %s
-                          AND status = 'approved'
-                          AND start_time < %s AND end_time > %s
-                        """,
-                        (res["resource_id"], res["reservation_id"],
-                         res["end_time"], res["start_time"]),
-                    )
-                    if cur.fetchone()[0] > 0:
-                        raise RuntimeError("Conflict: another reservation was approved for this time slot")
-
-                cur.execute(
-                    """
-                    UPDATE reservations
-                    SET status = %s, approved_by = %s
-                    WHERE reservation_id = %s AND status = 'pending'
-                    RETURNING reservation_id, status
-                    """,
-                    (new_status, admin_user_id, res["reservation_id"]),
-                )
-                result = cur.fetchone()
-        # Transaction committed automatically
+        with conn.cursor() as cur:
+            cur.execute(
+                """
+                UPDATE reservations
+                SET status = %s, approved_by = %s
+                WHERE reservation_id = %s AND status = 'pending'
+                RETURNING reservation_id, status
+                """,
+                (new_status, admin_user_id, res["reservation_id"]),
+            )
+            result = cur.fetchone()
+        conn.commit()
         if result:
             print(f"\n  Reservation #{result[0]} has been {result[1]}.")
@@ -156,4 +139,6 @@
             print("\n  Reservation was already processed by another administrator.")
     except Exception as e:
-        # Transaction rolled back automatically
+        conn.rollback()
         print(f"\n  Error: {e}")
+    finally:
+        conn.close()