aboutsummaryrefslogtreecommitdiff
path: root/src/mintdb/plugin_mintdb_postgres.c
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2015-05-14 14:37:12 +0200
committerChristian Grothoff <christian@grothoff.org>2015-05-14 14:37:12 +0200
commit701a10cbe7ed1bc762d5f1c2a843806f2856014e (patch)
tree7f0e0d187ca6e98324125edcd528a64531c93580 /src/mintdb/plugin_mintdb_postgres.c
parentd19b1277d1f8296c09675730ce5b971a3868fbd6 (diff)
avoid PG 9.5 dependency
Diffstat (limited to 'src/mintdb/plugin_mintdb_postgres.c')
-rw-r--r--src/mintdb/plugin_mintdb_postgres.c6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c
index 94aa3f633..706ea4736 100644
--- a/src/mintdb/plugin_mintdb_postgres.c
+++ b/src/mintdb/plugin_mintdb_postgres.c
@@ -226,11 +226,11 @@ postgres_create_tables (void *cls,
",PRIMARY KEY (reserve_pub,details)"
");");
/* Create indices on reserves_in */
- SQLEXEC_INDEX ("CREATE INDEX IF NOT EXISTS reserves_in_reserve_pub_index"
+ SQLEXEC_INDEX ("CREATE INDEX reserves_in_reserve_pub_index"
" ON reserves_in (reserve_pub);");
- SQLEXEC_INDEX ("CREATE INDEX IF NOT EXISTS reserves_in_reserve_pub_details_index"
+ SQLEXEC_INDEX ("CREATE INDEX reserves_in_reserve_pub_details_index"
" ON reserves_in (reserve_pub,details);");
- SQLEXEC_INDEX ("CREATE INDEX IF NOT EXISTS expiration_index"
+ SQLEXEC_INDEX ("CREATE INDEX expiration_index"
" ON reserves_in (expiration_date);");
/* Table with the withdraw operations that have been performed on a reserve.
TODO: maybe rename to "reserves_out"?