From 5c2c2dd78790bbd20e6d720fc1c7de532daf3b29 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Fri, 19 Jun 2015 11:28:03 +0200 Subject: remove primary key constraint to address #3769 --- src/mintdb/plugin_mintdb_postgres.c | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'src/mintdb/plugin_mintdb_postgres.c') diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c index e822c7113..836a8a8c8 100644 --- a/src/mintdb/plugin_mintdb_postgres.c +++ b/src/mintdb/plugin_mintdb_postgres.c @@ -384,8 +384,7 @@ postgres_create_tables (void *cls, and could be used by the mearchant for further inquriries about the deposit's execution. (#3816); */ SQLEXEC("CREATE TABLE IF NOT EXISTS deposits " - /* FIXME #3769: the following primary key may be too restrictive */ - "(coin_pub BYTEA NOT NULL PRIMARY KEY CHECK (LENGTH(coin_pub)=32)" + "(coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32)" ",denom_pub BYTEA NOT NULL REFERENCES denominations (pub)" ",denom_sig BYTEA NOT NULL" ",transaction_id INT8 NOT NULL" -- cgit v1.2.3