summaryrefslogtreecommitdiff
path: root/src/auditordb/plugin_auditordb_postgres.c
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2017-07-14 17:56:47 +0200
committerChristian Grothoff <christian@grothoff.org>2017-07-14 17:56:47 +0200
commit3a0e643b680962bddcab76f804253e9f321db5ec (patch)
treec82c0992390c23538999147abdc7663a33c1d362 /src/auditordb/plugin_auditordb_postgres.c
parent0ea012e316515bc41d11f7f6a0c78d0b08c4fb83 (diff)
downloadexchange-3a0e643b680962bddcab76f804253e9f321db5ec.tar.gz
exchange-3a0e643b680962bddcab76f804253e9f321db5ec.tar.bz2
exchange-3a0e643b680962bddcab76f804253e9f321db5ec.zip
add UNIQUE constraint on BIGSERIAL columns as that is not automatic in Postgres
Diffstat (limited to 'src/auditordb/plugin_auditordb_postgres.c')
-rw-r--r--src/auditordb/plugin_auditordb_postgres.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/auditordb/plugin_auditordb_postgres.c b/src/auditordb/plugin_auditordb_postgres.c
index e31bb025..3917aa94 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)"),