From 0ea012e316515bc41d11f7f6a0c78d0b08c4fb83 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Fri, 14 Jul 2017 17:52:09 +0200 Subject: make reserves_update more canonical, avoiding odd WHERE constraint that is unnecessary --- src/exchangedb/plugin_exchangedb_postgres.c | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'src/exchangedb/plugin_exchangedb_postgres.c') diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c index 7b84b232e..06a6f879e 100644 --- a/src/exchangedb/plugin_exchangedb_postgres.c +++ b/src/exchangedb/plugin_exchangedb_postgres.c @@ -566,10 +566,11 @@ postgres_prepare (PGconn *db_conn) "UPDATE reserves" " SET" " expiration_date=$1 " - ",current_balance_val=$2 " + ",current_balance_val=$2" ",current_balance_frac=$3" - " WHERE current_balance_curr=$4" - " AND reserve_pub=$5;", + ",current_balance_curr=$4" + " WHERE" + " reserve_pub=$5;", 5), /* Used in #postgres_reserves_in_insert() to store transaction details */ GNUNET_PQ_make_prepare ("reserves_in_add_transaction", -- cgit v1.2.3