From 81400220f84892e869fb74a700d14fd4e26afb12 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Tue, 9 Jan 2024 12:12:09 +0100
Subject: fix SQL

---
 contrib/gana                            |  2 +-
 doc/prebuilt                            |  2 +-
 src/auditordb/0002-auditor-triggers.sql | 13 +++++++------
 3 files changed, 9 insertions(+), 8 deletions(-)

diff --git a/contrib/gana b/contrib/gana
index 9eddc2cf7..6d3fb428f 160000
--- a/contrib/gana
+++ b/contrib/gana
@@ -1 +1 @@
-Subproject commit 9eddc2cf7b65bb43d285c75ef22fd9bc9cc7020e
+Subproject commit 6d3fb428f0a2dd5bc5f35516ea77c32c2cf0ecfa
diff --git a/doc/prebuilt b/doc/prebuilt
index 5e7026c5c..5e47a72e8 160000
--- a/doc/prebuilt
+++ b/doc/prebuilt
@@ -1 +1 @@
-Subproject commit 5e7026c5cef101c90b6dc58096e0a0946ef11b08
+Subproject commit 5e47a72e8a2b5086dfdae4078f695155f5ed7af8
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();
+
-- 
cgit v1.2.3