summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKarsten Loesing <karsten.loesing@gmx.net>2018-09-13 17:16:11 +0200
committerKarsten Loesing <karsten.loesing@gmx.net>2018-09-13 17:16:11 +0200
commitb64f4d1c1320c1f43d1e5dc67549897b2e2e8e66 (patch)
treef6eb29468865cf42ecb8359abee2a390c49334f8
parentc9db91dbb32422baf6a3be0ed14d0811b3c2e098 (diff)
squash! Reduce database size and variance of query response times.task-27356
- In exonerator2.sql, exit on first error, which prevents multiple executions of that file.
-rwxr-xr-xsrc/main/sql/exonerator2.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/src/main/sql/exonerator2.sql b/src/main/sql/exonerator2.sql
index 8fec84b..397d2bf 100755
--- a/src/main/sql/exonerator2.sql
+++ b/src/main/sql/exonerator2.sql
@@ -24,6 +24,9 @@
-- - Update the Java importer and servlets to use the new functions.
-- - Turn the importer back on.
+-- Exit on first error, which prevents multiple executions of this file.
+\set ON_ERROR_STOP true
+
-- The fingerprint table stores fingerprint strings uniquely identifying relays
-- and assigns much shorter numeric identifiers for internal-only use.
CREATE TABLE fingerprint (