-misc fixes

1 files changed, 25 insertions, 29 deletions

diff --git a/src/exchangedb/exchange_do_reserves_in_insert.sql b/src/exchangedb/exchange_do_reserves_in_insert.sql
index dd202a2ae..6cd5847df 100644
--- a/src/exchangedb/exchange_do_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_reserves_in_insert.sql
@@ -146,13 +146,11 @@ AS $$
 DECLARE
   curs_reserve_exist REFCURSOR;
 DECLARE
+  k INT8;
+DECLARE
   curs_transaction_exist REFCURSOR;
 DECLARE
   i RECORD;
-DECLARE
-  r RECORD;
-DECLARE
-  k INT8;
 BEGIN
   transaction_duplicate0 = TRUE;
   transaction_duplicate1 = TRUE;
@@ -228,35 +226,33 @@ BEGIN
 
   OPEN curs_transaction_exist FOR
   WITH reserve_transaction AS (
-  INSERT INTO reserves_in
-    (reserve_pub
-    ,wire_reference
-    ,credit_val
-    ,credit_frac
-    ,exchange_account_section
-    ,wire_source_h_payto
-    ,execution_date)
-    VALUES
-    (in0_reserve_pub
-    ,in0_wire_ref
-    ,in0_credit_val
-    ,in0_credit_frac
-    ,in0_exchange_account_name
-    ,in0_wire_source_h_payto
-    ,in0_execution_date),
-    (in1_reserve_pub
-    ,in1_wire_ref
-    ,in1_credit_val
-    ,in1_credit_frac
-    ,in1_exchange_account_name
-    ,in1_wire_source_h_payto
-    ,in1_execution_date)
+    INSERT INTO reserves_in
+      (reserve_pub
+      ,wire_reference
+      ,credit_val
+      ,credit_frac
+      ,exchange_account_section
+      ,wire_source_h_payto
+      ,execution_date)
+      VALUES
+      (in0_reserve_pub
+      ,in0_wire_ref
+      ,in0_credit_val
+      ,in0_credit_frac
+      ,in0_exchange_account_name
+      ,in0_wire_source_h_payto
+      ,in0_execution_date),
+      (in1_reserve_pub
+      ,in1_wire_ref
+      ,in1_credit_val
+      ,in1_credit_frac
+      ,in1_exchange_account_name
+      ,in1_wire_source_h_payto
+      ,in1_execution_date)
     ON CONFLICT DO NOTHING
     RETURNING reserve_pub)
   SELECT reserve_pub FROM reserve_transaction;
 
-  FETCH FROM curs_transaction_exist INTO r;
-
   k=0;
   <<loop_transaction>> LOOP
     FETCH FROM curs_transaction_exist INTO i;