X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/5e477e3b5b99da6fc4e54749d4671a6fc8fdcd66..98c1b923fc090f830b7b3a575e3d08ba399bd870:/lib-sql/tiger_import_finish.sql?ds=sidebyside diff --git a/lib-sql/tiger_import_finish.sql b/lib-sql/tiger_import_finish.sql index c02ce2a3..b7c32d72 100644 --- a/lib-sql/tiger_import_finish.sql +++ b/lib-sql/tiger_import_finish.sql @@ -8,9 +8,7 @@ --index only on parent_place_id CREATE INDEX IF NOT EXISTS idx_location_property_tiger_parent_place_id_imp ON location_property_tiger_import (parent_place_id) -{% if postgres.has_index_non_key_column %} INCLUDE (startnumber, endnumber, step) -{% endif %} {{db.tablespace.aux_index}}; CREATE UNIQUE INDEX IF NOT EXISTS idx_location_property_tiger_place_id_imp ON location_property_tiger_import (place_id) {{db.tablespace.aux_index}};