From ca8eb3ec5c55cfd3c3903d8aed7a76d04b5d4ce4 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Wed, 3 Jun 2015 14:12:26 +0200
Subject: remarks on #3813

---
 src/mintdb/plugin_mintdb_postgres.c | 24 +++++++++++++-----------
 1 file changed, 13 insertions(+), 11 deletions(-)

(limited to 'src')

diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c
index ecf27e626..31353702f 100644
--- a/src/mintdb/plugin_mintdb_postgres.c
+++ b/src/mintdb/plugin_mintdb_postgres.c
@@ -547,34 +547,34 @@ postgres_prepare (PGconn *db_conn)
            " transfer_pub "
            ",link_secret_enc "
            "FROM refresh_commit_link "
-           "WHERE session_hash = $1 AND cnc_index = $2 AND oldcoin_index = $3",
+           "WHERE session_hash=$1 AND cnc_index=$2 AND oldcoin_index=$3",
            3, NULL);
   PREPARE ("get_refresh_commit_coin",
            "SELECT"
            " link_vector_enc "
            ",coin_ev "
            "FROM refresh_commit_coin "
-           "WHERE session_hash = $1 AND cnc_index = $2 AND newcoin_index = $3",
+           "WHERE session_hash=$1 AND cnc_index=$2 AND newcoin_index=$3",
            3, NULL);
   PREPARE ("insert_refresh_order",
-           "INSERT INTO refresh_order ("
-           " newcoin_index "
+           "INSERT INTO refresh_order "
+           "(newcoin_index "
            ",session_hash "
            ",denom_pub "
-           ") "
-           "VALUES ($1, $2, $3)",
+           ") VALUES "
+           "($1, $2, $3);",
            3, NULL);
   PREPARE ("insert_refresh_melt",
-           "INSERT INTO refresh_melts ("
-           " coin_pub "
+           "INSERT INTO refresh_melts "
+           "(coin_pub "
            ",session"
            ",oldcoin_index "
            ",coin_sig "
            ",amount_val "
            ",amount_frac "
            ",amount_curr "
-           ") "
-           "VALUES ($1, $2, $3, $4, $5, $6, $7)",
+           ") VALUES "
+           "($1, $2, $3, $4, $5, $6, $7);",
            7, NULL);
   PREPARE ("get_refresh_melt",
            "SELECT"
@@ -584,8 +584,10 @@ postgres_prepare (PGconn *db_conn)
            ",amount_frac"
            ",amount_curr"
            " FROM refresh_melts "
-           "WHERE session = $1 AND oldcoin_index = $2",
+           "WHERE session=$1 AND oldcoin_index=$2",
            2, NULL);
+  /* FIXME: should have a way to query the 'refresh_melts' by
+     coin public key (#3813) */
   PREPARE ("get_refresh_order",
            "SELECT denom_pub "
            "FROM refresh_order "
-- 
cgit v1.2.3