aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_reserve_purse.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-01-16 15:45:35 +0100
committerChristian Grothoff <christian@grothoff.org>2023-01-16 15:45:35 +0100
commit6596e6c72362d3cbc6b383feb22b3a99717dbf66 (patch)
treebfc267c758b672682dc9cd08f2423d275e59eabb /src/exchangedb/exchange_do_reserve_purse.sql
parent402ca17600d57e2a3569771eb57881c42d5db0e4 (diff)
downloadexchange-6596e6c72362d3cbc6b383feb22b3a99717dbf66.tar.xz
fix for foreign key constraint problem for free purses on purse creation from reserve
Diffstat (limited to 'src/exchangedb/exchange_do_reserve_purse.sql')
-rw-r--r--src/exchangedb/exchange_do_reserve_purse.sql12
1 files changed, 11 insertions, 1 deletions
diff --git a/src/exchangedb/exchange_do_reserve_purse.sql b/src/exchangedb/exchange_do_reserve_purse.sql
index a110c85a3..4f65c6606 100644
--- a/src/exchangedb/exchange_do_reserve_purse.sql
+++ b/src/exchangedb/exchange_do_reserve_purse.sql
@@ -18,6 +18,8 @@ CREATE OR REPLACE FUNCTION exchange_do_reserve_purse(
IN in_purse_pub BYTEA,
IN in_merge_sig BYTEA,
IN in_merge_timestamp INT8,
+ IN in_reserve_expiration INT8,
+ IN in_reserve_gc INT8,
IN in_reserve_sig BYTEA,
IN in_reserve_quota BOOLEAN,
IN in_purse_fee_val INT8,
@@ -105,6 +107,14 @@ ELSE
out_no_funds=TRUE;
RETURN;
END IF;
+ INSERT INTO exchange.reserves
+ (reserve_pub
+ ,expiration_date
+ ,gc_date)
+ VALUES
+ (in_reserve_pub
+ ,in_reserve_expiration
+ ,in_reserve_gc);
ELSE
UPDATE exchange.reserves
SET
@@ -149,7 +159,7 @@ INSERT INTO exchange.account_merges
END $$;
-COMMENT ON FUNCTION exchange_do_reserve_purse(BYTEA, BYTEA, INT8, BYTEA, BOOLEAN, INT8, INT4, BYTEA, BYTEA)
+COMMENT ON FUNCTION exchange_do_reserve_purse(BYTEA, BYTEA, INT8, INT8, INT8, BYTEA, BOOLEAN, INT8, INT4, BYTEA, BYTEA)
IS 'Create a purse for a reserve.';