From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 3 Feb 2021 09:39:41 +0000 (+0100)
Subject: reenable code for copying the final tiger data
X-Git-Tag: deploy~186
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/bb6c8d45fe688b593caedf359a3c19acfec7dad1

reenable code for copying the final tiger data
---

diff --git a/sql/tiger_import_finish.sql b/sql/tiger_import_finish.sql
index 09942bac..374c00b3 100644
--- a/sql/tiger_import_finish.sql
+++ b/sql/tiger_import_finish.sql
@@ -4,10 +4,10 @@ CREATE UNIQUE INDEX idx_location_property_tiger_place_id_imp ON location_propert
 
 GRANT SELECT ON location_property_tiger_import TO "{www-user}";
 
---DROP TABLE IF EXISTS location_property_tiger;
---ALTER TABLE location_property_tiger_import RENAME TO location_property_tiger;
+DROP TABLE IF EXISTS location_property_tiger;
+ALTER TABLE location_property_tiger_import RENAME TO location_property_tiger;
 
---ALTER INDEX idx_location_property_tiger_parent_place_id_imp RENAME TO idx_location_property_tiger_housenumber_parent_place_id;
---ALTER INDEX idx_location_property_tiger_place_id_imp RENAME TO idx_location_property_tiger_place_id;
+ALTER INDEX idx_location_property_tiger_parent_place_id_imp RENAME TO idx_location_property_tiger_housenumber_parent_place_id;
+ALTER INDEX 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);