fix SQL

3 files changed, 7 insertions, 6 deletions

diff --git a/contrib/gana b/contrib/gana
-Subproject 9eddc2cf7b65bb43d285c75ef22fd9bc9cc7020
+Subproject 6d3fb428f0a2dd5bc5f35516ea77c32c2cf0ecf
diff --git a/doc/prebuilt b/doc/prebuilt
-Subproject 5e7026c5cef101c90b6dc58096e0a0946ef11b0
+Subproject 5e47a72e8a2b5086dfdae4078f695155f5ed7af
diff --git a/src/auditordb/0002-auditor-triggers.sql b/src/auditordb/0002-auditor-triggers.sql
index 43d8eb8f6..ce4b66b7b 100644
--- a/src/auditordb/0002-auditor-triggers.sql
+++ b/src/auditordb/0002-auditor-triggers.sql
@@ -1,19 +1,20 @@
 SET search_path TO auditor;
 
-CREATE TRIGGER auditor_notify_helper_deposits
-    AFTER INSERT
-    ON auditor.deposit_confirmations
-EXECUTE PROCEDURE auditor_new_transactions_trigger();
-
 CREATE OR REPLACE FUNCTION auditor_new_transactions_trigger()
     RETURNS trigger
     LANGUAGE plpgsql
 AS $$
 BEGIN
     -- TODO Add correct notify string
-    PERFORM('NOTIFY XRE2709K6TYDBVARD9Y5SCZY7VHE4D5DKF0R8DHQ4X5T13E8X2X60');
+    NOTIFY XRE2709K6TYDBVARD9Y5SCZY7VHE4D5DKF0R8DHQ4X5T13E8X2X60;
     RETURN NEW;
 END $$;
 COMMENT ON FUNCTION auditor_new_transactions_trigger()
     IS 'Call auditor_call_db_notify on new entry';
 
+
+CREATE TRIGGER auditor_notify_helper_deposits
+    AFTER INSERT
+    ON auditor.deposit_confirmations
+EXECUTE PROCEDURE auditor_new_transactions_trigger();
+