aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
m---------contrib/gana0
m---------doc/prebuilt0
-rw-r--r--src/auditordb/0002-auditor-triggers.sql13
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();
+