search_name.name_vector index is now required during initial index due to code to...

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index 1664a96bf60af2a38e9d04804a170375bc62b218..05cbd90d556045fcb9cedb4ced8101961304418c 100644 (file)
--- 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 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);
 
 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 a3e50953dcd1be607a84c4dcdcf246d863826e5c..51690ae079ad101117e0015967b31e40c48032cb 100644 (file)
--- 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);
 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 (
 
 drop table IF EXISTS place_addressline;
 CREATE TABLE place_addressline (