lib-sql/tiger_import_finish.sql

   1 --index only on parent_place_id
   2 CREATE INDEX IF NOT EXISTS idx_location_property_tiger_parent_place_id_imp
   3   ON location_property_tiger_import (parent_place_id) {{db.tablespace.aux_index}};
   4 CREATE UNIQUE INDEX IF NOT EXISTS idx_location_property_tiger_place_id_imp
   5   ON location_property_tiger_import (place_id) {{db.tablespace.aux_index}};
   6
   7 GRANT SELECT ON location_property_tiger_import TO "{{config.DATABASE_WEBUSER}}";
   8
   9 DROP TABLE IF EXISTS location_property_tiger;
  10 ALTER TABLE location_property_tiger_import RENAME TO location_property_tiger;
  11
  12 ALTER INDEX IF EXISTS idx_location_property_tiger_parent_place_id_imp RENAME TO idx_location_property_tiger_housenumber_parent_place_id;
  13 ALTER INDEX IF EXISTS idx_location_property_tiger_place_id_imp RENAME TO idx_location_property_tiger_place_id;
  14
  15 DROP FUNCTION tiger_line_import (linegeo GEOMETRY, in_startnumber INTEGER,
  16                                  in_endnumber INTEGER, interpolationtype TEXT,
  17                                  token_info JSONB, in_postcode TEXT);