summaryrefslogtreecommitdiff
path: root/tools/purge.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tools/purge.sql')
-rw-r--r--tools/purge.sql2
1 files changed, 1 insertions, 1 deletions
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);