summaryrefslogtreecommitdiff
path: root/src/backenddb/pg_refund_coin.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/backenddb/pg_refund_coin.c')
-rw-r--r--src/backenddb/pg_refund_coin.c14
1 files changed, 8 insertions, 6 deletions
diff --git a/src/backenddb/pg_refund_coin.c b/src/backenddb/pg_refund_coin.c
index afbcebcc..1bde2974 100644
--- a/src/backenddb/pg_refund_coin.c
+++ b/src/backenddb/pg_refund_coin.c
@@ -53,15 +53,17 @@ TMH_PG_refund_coin (void *cls,
",refund_amount"
") "
"SELECT "
- " order_serial"
+ " dcon.order_serial"
",0" /* rtransaction_id always 0 for /abort */
",$3"
- ",coin_pub"
+ ",dep.coin_pub"
",$5"
- ",amount_with_fee"
- " FROM merchant_deposits"
- " WHERE coin_pub=$4"
- " AND order_serial="
+ ",dep.amount_with_fee"
+ " FROM merchant_deposits dep"
+ " JOIN merchant_deposit_confirmations dcon"
+ " USING (deposit_confirmation_serial)"
+ " WHERE dep.coin_pub=$4"
+ " AND dcon.order_serial="
" (SELECT order_serial"
" FROM merchant_contract_terms"
" WHERE h_contract_terms=$2"