X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9086a794a1ca9ed08d66c9aca5cea25d1f6006bf..8413075249e1bb2832df4edd0f66d61f77fb9f99:/lib-sql/tiger_import_finish.sql diff --git a/lib-sql/tiger_import_finish.sql b/lib-sql/tiger_import_finish.sql index 39ab1ae3..a084a2e2 100644 --- a/lib-sql/tiger_import_finish.sql +++ b/lib-sql/tiger_import_finish.sql @@ -1,5 +1,5 @@ --index only on parent_place_id -CREATE INDEX {{sql.if_index_not_exists}} idx_location_property_tiger_place_id_imp +CREATE INDEX {{sql.if_index_not_exists}} idx_location_property_tiger_parent_place_id_imp ON location_property_tiger_import (parent_place_id) {{db.tablespace.aux_index}}; CREATE UNIQUE INDEX {{sql.if_index_not_exists}} idx_location_property_tiger_place_id_imp ON location_property_tiger_import (place_id) {{db.tablespace.aux_index}}; @@ -12,4 +12,6 @@ ALTER TABLE location_property_tiger_import RENAME TO location_property_tiger; ALTER INDEX IF EXISTS idx_location_property_tiger_parent_place_id_imp RENAME TO idx_location_property_tiger_housenumber_parent_place_id; ALTER INDEX IF EXISTS idx_location_property_tiger_place_id_imp RENAME TO idx_location_property_tiger_place_id; -DROP FUNCTION tiger_line_import (linegeo geometry, in_startnumber integer, in_endnumber integer, interpolationtype text, in_street text, in_isin text, in_postcode text); +DROP FUNCTION tiger_line_import (linegeo GEOMETRY, in_startnumber INTEGER, + in_endnumber INTEGER, interpolationtype TEXT, + token_info JSONB, in_postcode TEXT);