diff options
| author | Tor Andersson <tor@ccxvii.net> | 2024-04-13 19:26:27 +0200 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2025-02-14 01:36:03 +0100 |
| commit | cd0359922e573490754be5528d4af5b1a03bb342 (patch) | |
| tree | 3542cfc11f826e91527e34258cbce42ed824049d /tools/purge.sql | |
| parent | b365e462d00f35ae3515eef9e2dfc6b9ade99107 (diff) | |
| download | server-cd0359922e573490754be5528d4af5b1a03bb342.tar.gz | |
Use begin immediate transactions.
Diffstat (limited to 'tools/purge.sql')
| -rw-r--r-- | tools/purge.sql | 2 |
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); |