diff options
| author | Christian Grothoff <christian@grothoff.org> | 2017-07-14 17:56:47 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2017-07-14 17:56:47 +0200 |
| commit | 3a0e643b680962bddcab76f804253e9f321db5ec (patch) | |
| tree | c82c0992390c23538999147abdc7663a33c1d362 /src/auditordb/plugin_auditordb_postgres.c | |
| parent | 0ea012e316515bc41d11f7f6a0c78d0b08c4fb83 (diff) | |
| download | exchange-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.c | 2 |
1 files changed, 1 insertions, 1 deletions
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)"), |