From: Brian Quinion <openstreetmap@brian.quinion.co.uk>
Date: Sun, 1 Apr 2012 12:52:58 +0000 (+0100)
Subject: search_name.name_vector index is now required during initial index due to code to... 
X-Git-Tag: v2.0.0~93
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/5e167f49d2985285a11b8b175d7175fa5351ac24

search_name.name_vector index is now required during initial index due to code to merge relations and nodes
---

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index 1664a96b..05cbd90d 100644
--- a/sql/indices.src.sql
+++ b/sql/indices.src.sql
@@ -1,6 +1,5 @@
 CREATE INDEX idx_word_word_id on word USING BTREE (word_id);
 
-CREATE INDEX search_name_name_vector_idx ON search_name USING GIN (name_vector) WITH (fastupdate = off);
 CREATE INDEX searchnameplacesearch_search_nameaddress_vector_idx ON search_name USING GIN (nameaddress_vector) WITH (fastupdate = off);
 CREATE INDEX idx_search_name_centroid ON search_name USING GIST (centroid);
 
diff --git a/sql/tables.sql b/sql/tables.sql
index a3e50953..51690ae0 100644
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -138,6 +138,7 @@ SELECT AddGeometryColumn('search_name_blank', 'centroid', 4326, 'GEOMETRY', 2);
 drop table IF EXISTS search_name;
 CREATE TABLE search_name () INHERITS (search_name_blank);
 CREATE INDEX idx_search_name_place_id ON search_name USING BTREE (place_id);
+CREATE INDEX search_name_name_vector_idx ON search_name USING GIN (name_vector) WITH (fastupdate = off);
 
 drop table IF EXISTS place_addressline;
 CREATE TABLE place_addressline (