diff options
| m--------- | contrib/gana | 0 | ||||
| m--------- | doc/prebuilt | 0 | ||||
| -rw-r--r-- | src/auditordb/0002-auditor-triggers.sql | 13 |
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(); + |