diff options
| author | Daniel Golle <daniel@makrotopia.org> | 2016-10-13 00:29:39 +0000 |
|---|---|---|
| committer | Daniel Golle <daniel@makrotopia.org> | 2016-10-13 00:29:39 +0000 |
| commit | 17fe492dd48812f839eee1de813f2c7b906bc907 (patch) | |
| tree | 826463576dc82425bedc28a954c4d76d9bf8c298 /src/namestore | |
| parent | 41e2d697bb63faabe9ffbaccd7ca5d9b93989d6b (diff) | |
| download | gnunet-17fe492dd48812f839eee1de813f2c7b906bc907.tar.gz gnunet-17fe492dd48812f839eee1de813f2c7b906bc907.zip | |
namestore: postgres: use IF NOT EXISTS to avoid error messages
Diffstat (limited to 'src/namestore')
| -rw-r--r-- | src/namestore/plugin_namestore_postgres.c | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/namestore/plugin_namestore_postgres.c b/src/namestore/plugin_namestore_postgres.c index 8ea6b43ad..01dbf9e61 100644 --- a/src/namestore/plugin_namestore_postgres.c +++ b/src/namestore/plugin_namestore_postgres.c | |||
| @@ -85,14 +85,14 @@ create_indices (PGconn * dbh) | |||
| 85 | /* create indices */ | 85 | /* create indices */ |
| 86 | if ( (GNUNET_OK != | 86 | if ( (GNUNET_OK != |
| 87 | GNUNET_POSTGRES_exec (dbh, | 87 | GNUNET_POSTGRES_exec (dbh, |
| 88 | "CREATE INDEX ir_pkey_reverse ON ns097records (zone_private_key,pkey)")) || | 88 | "CREATE INDEX IF NOT EXISTS ir_pkey_reverse ON ns097records (zone_private_key,pkey)")) || |
| 89 | (GNUNET_OK != | 89 | (GNUNET_OK != |
| 90 | GNUNET_POSTGRES_exec (dbh, | 90 | GNUNET_POSTGRES_exec (dbh, |
| 91 | "CREATE INDEX ir_pkey_iter ON ns097records (zone_private_key,rvalue)")) || | 91 | "CREATE INDEX IF NOT EXISTS ir_pkey_iter ON ns097records (zone_private_key,rvalue)")) || |
| 92 | (GNUNET_OK != | 92 | (GNUNET_OK != |
| 93 | GNUNET_POSTGRES_exec (dbh, "CREATE INDEX it_iter ON ns097records (rvalue)")) || | 93 | GNUNET_POSTGRES_exec (dbh, "CREATE INDEX IF NOT EXISTS it_iter ON ns097records (rvalue)")) || |
| 94 | (GNUNET_OK != | 94 | (GNUNET_OK != |
| 95 | GNUNET_POSTGRES_exec (dbh, "CREATE INDEX ir_label ON ns097records (label)")) ) | 95 | GNUNET_POSTGRES_exec (dbh, "CREATE INDEX IF NOT EXISTS ir_label ON ns097records (label)")) ) |
| 96 | LOG (GNUNET_ERROR_TYPE_ERROR, | 96 | LOG (GNUNET_ERROR_TYPE_ERROR, |
| 97 | _("Failed to create indices\n")); | 97 | _("Failed to create indices\n")); |
| 98 | } | 98 | } |
| @@ -122,7 +122,7 @@ database_setup (struct Plugin *plugin) | |||
| 122 | { | 122 | { |
| 123 | res = | 123 | res = |
| 124 | PQexec (plugin->dbh, | 124 | PQexec (plugin->dbh, |
| 125 | "CREATE TEMPORARY TABLE ns097records (" | 125 | "CREATE TEMPORARY TABLE IF NOT EXISTS ns097records (" |
| 126 | " zone_private_key BYTEA NOT NULL DEFAULT ''," | 126 | " zone_private_key BYTEA NOT NULL DEFAULT ''," |
| 127 | " pkey BYTEA DEFAULT ''," | 127 | " pkey BYTEA DEFAULT ''," |
| 128 | " rvalue BYTEA NOT NULL DEFAULT ''," | 128 | " rvalue BYTEA NOT NULL DEFAULT ''," |
| @@ -135,7 +135,7 @@ database_setup (struct Plugin *plugin) | |||
| 135 | { | 135 | { |
| 136 | res = | 136 | res = |
| 137 | PQexec (plugin->dbh, | 137 | PQexec (plugin->dbh, |
| 138 | "CREATE TABLE ns097records (" | 138 | "CREATE TABLE IF NOT EXISTS ns097records (" |
| 139 | " zone_private_key BYTEA NOT NULL DEFAULT ''," | 139 | " zone_private_key BYTEA NOT NULL DEFAULT ''," |
| 140 | " pkey BYTEA DEFAULT ''," | 140 | " pkey BYTEA DEFAULT ''," |
| 141 | " rvalue BYTEA NOT NULL DEFAULT ''," | 141 | " rvalue BYTEA NOT NULL DEFAULT ''," |