X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/c4f22a42eba499ed1854c5967b2e3932fe9b3896..f3c557bf684a0079e4bc54b622cc5d766f3a6b56:/lib-sql/tiger_import_finish.sql diff --git a/lib-sql/tiger_import_finish.sql b/lib-sql/tiger_import_finish.sql index afe69c37..c02ce2a3 100644 --- a/lib-sql/tiger_import_finish.sql +++ b/lib-sql/tiger_import_finish.sql @@ -9,7 +9,7 @@ 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) + INCLUDE (startnumber, endnumber, step) {% endif %} {{db.tablespace.aux_index}}; CREATE UNIQUE INDEX IF NOT EXISTS idx_location_property_tiger_place_id_imp