diff options
Diffstat (limited to 'src/sql')
| -rw-r--r-- | src/sql/accessLogPurgeOld.sql | 2 | ||||
| -rw-r--r-- | src/sql/selectUninsertableLines.sql | 1 |
2 files changed, 1 insertions, 2 deletions
diff --git a/src/sql/accessLogPurgeOld.sql b/src/sql/accessLogPurgeOld.sql index 00e55b5..616b3a6 100644 --- a/src/sql/accessLogPurgeOld.sql +++ b/src/sql/accessLogPurgeOld.sql @@ -5,8 +5,6 @@ WITH delete_batch AS ( access_log WHERE request_time < CURRENT_DATE - ?::interval - ORDER BY - request_time FOR UPDATE LIMIT ?) DELETE FROM access_log AS al USING delete_batch AS del diff --git a/src/sql/selectUninsertableLines.sql b/src/sql/selectUninsertableLines.sql index 5c07791..894ab67 100644 --- a/src/sql/selectUninsertableLines.sql +++ b/src/sql/selectUninsertableLines.sql @@ -9,3 +9,4 @@ WHERE ORDER BY id LIMIT ? +FOR UPDATE |