From 3a0e643b680962bddcab76f804253e9f321db5ec Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Fri, 14 Jul 2017 17:56:47 +0200 Subject: add UNIQUE constraint on BIGSERIAL columns as that is not automatic in Postgres --- src/auditordb/plugin_auditordb_postgres.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/auditordb/plugin_auditordb_postgres.c') diff --git a/src/auditordb/plugin_auditordb_postgres.c b/src/auditordb/plugin_auditordb_postgres.c index e31bb0257..3917aa945 100644 --- a/src/auditordb/plugin_auditordb_postgres.c +++ b/src/auditordb/plugin_auditordb_postgres.c @@ -244,7 +244,7 @@ postgres_create_tables (void *cls) ",withdraw_fee_balance_frac INT4 NOT NULL" ",withdraw_fee_balance_curr VARCHAR("TALER_CURRENCY_LEN_STR") NOT NULL" ",expiration_date INT8 NOT NULL" - ",auditor_reserves_rowid BIGSERIAL" + ",auditor_reserves_rowid BIGSERIAL UNIQUE" ")"), GNUNET_PQ_make_try_execute ("CREATE INDEX auditor_reserves_by_reserve_pub " "ON auditor_reserves(reserve_pub)"), -- cgit v1.2.3