From cd0359922e573490754be5528d4af5b1a03bb342 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sat, 13 Apr 2024 19:26:27 +0200
Subject: Use begin immediate transactions.

---
 tools/purge.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'tools/purge.sql')

diff --git a/tools/purge.sql b/tools/purge.sql
index 3e0c898..add6e2d 100644
--- a/tools/purge.sql
+++ b/tools/purge.sql
@@ -26,7 +26,7 @@ create temporary view prune_all_list as
 		)
 	;
 
-begin;
+begin immediate;
 
 select 'PURGE SNAPS FROM ' || count(1) from prune_snap_list;
 delete from live.game_snap where game_id in (select game_id from prune_snap_list);
-- 
cgit v1.2.3

