diff options
Diffstat (limited to 'src/exchangedb/0002-purse_decision.sql')
| -rw-r--r-- | src/exchangedb/0002-purse_decision.sql | 25 |
1 files changed, 14 insertions, 11 deletions
diff --git a/src/exchangedb/0002-purse_decision.sql b/src/exchangedb/0002-purse_decision.sql index 3eeeea8a7..bd712ad25 100644 --- a/src/exchangedb/0002-purse_decision.sql +++ b/src/exchangedb/0002-purse_decision.sql @@ -1,6 +1,6 @@ -- -- This file is part of TALER --- Copyright (C) 2014--2022 Taler Systems SA +-- Copyright (C) 2014--2023 Taler Systems SA -- -- TALER is free software; you can redistribute it and/or modify it under the -- terms of the GNU General Public License as published by the Free Software @@ -74,16 +74,19 @@ CREATE OR REPLACE FUNCTION purse_decision_insert_trigger() LANGUAGE plpgsql AS $$ BEGIN - INSERT INTO exchange.coin_history - (coin_pub - ,table_name - ,serial_id) - SELECT - pd.coin_pub - ,'purse_decision' - ,NEW.purse_decision_serial_id - FROM purse_deposits pd - WHERE purse_pub = NEW.purse_pub; + IF NEW.refunded + THEN + INSERT INTO exchange.coin_history + (coin_pub + ,table_name + ,serial_id) + SELECT + pd.coin_pub + ,'purse_decision' + ,NEW.purse_decision_serial_id + FROM purse_deposits pd + WHERE purse_pub = NEW.purse_pub; + END IF; RETURN NEW; END $$; COMMENT ON FUNCTION purse_decision_insert_trigger() |