exchange

commit 81400220f84892e869fb74a700d14fd4e26afb12
parent be6a38906f42b44032616e77c59191eda3eb68cd
Author: Christian Grothoff <christian@grothoff.org>
Date:   Tue,  9 Jan 2024 12:12:09 +0100

fix SQL

Diffstat:
M
src/auditordb/0002-auditor-triggers.sql
 | 
13
+++++++------

1 file changed, 7 insertions(+), 6 deletions(-)
diff --git 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();
+