diff options
author | Christian Grothoff <christian@grothoff.org> | 2015-06-03 12:35:30 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2015-06-03 12:35:30 +0200 |
commit | f8558c418ee4e4ff6dd5cac1b1711999f8ace20d (patch) | |
tree | f4e307ae9ad6e2ed4bc215d2176b4629e9180140 /src/mintdb | |
parent | 510c45efd62201b6b651e86053b17a98239b067d (diff) | |
download | exchange-f8558c418ee4e4ff6dd5cac1b1711999f8ace20d.tar.xz |
remarks on #3811
Diffstat (limited to 'src/mintdb')
-rw-r--r-- | src/mintdb/plugin_mintdb_postgres.c | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c index a54c6b9ce..7982f8be7 100644 --- a/src/mintdb/plugin_mintdb_postgres.c +++ b/src/mintdb/plugin_mintdb_postgres.c @@ -280,7 +280,7 @@ postgres_create_tables (void *cls, " collectable_blindcoins (reserve_pub)"); /* Table with coins that have been (partially) spent, used to detect double-spending. - TODO: maybe rename to "spent_coins"? (#3811) */ + TODO: maybe eliminate, this might be over-normalization (#3811) */ SQLEXEC("CREATE TABLE IF NOT EXISTS known_coins " "(coin_pub BYTEA NOT NULL PRIMARY KEY" ",denom_pub BYTEA NOT NULL REFERENCES denominations (pub)" @@ -523,9 +523,10 @@ postgres_prepare (PGconn *db_conn) 4, NULL); PREPARE ("get_known_coin", "SELECT" - " denom_pub, denom_sig " - "FROM known_coins " - "WHERE coin_pub = $1", + " denom_pub" + ",denom_sig" + " FROM known_coins " + " WHERE coin_pub=$1", 1, NULL); PREPARE ("insert_known_coin", "INSERT INTO known_coins (" |