From a0bc1ca4928edc40621fa2653eae8ade1647d227 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 4 Jan 2018 19:36:14 +0000 Subject: [PATCH] share/sql/geo.sql --- share/sql/geo.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/share/sql/geo.sql b/share/sql/geo.sql index c567b051..655caf0b 100644 --- a/share/sql/geo.sql +++ b/share/sql/geo.sql @@ -42,7 +42,7 @@ CREATE TABLE IF NOT EXISTS geo ( GRANT ALL ON ALL TABLES IN SCHEMA public TO www; GRANT ALL ON ALL TABLES IN SCHEMA public TO nico; GRANT ALL ON ALL TABLES IN SCHEMA public TO root; -CREATE INDEX geo_country_idx ON geo (country); +CREATE INDEX IF NOT EXISTS geo_country_idx ON geo (country); BEGIN TRANSACTION; DELETE FROM geo; COPY geo FROM PROGRAM 'curl -s http://download.geonames.org/export/dump/allCountries.zip | zcat' WITH (format 'text', NULL ''); -- 2.47.3