From dd97528726152e8f4e47aa6433acc30e94198644 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 21 May 2015 23:35:04 +0200 Subject: [PATCH] get rid of sector index, no longer used --- sql/tables.sql | 3 --- 1 file changed, 3 deletions(-) diff --git a/sql/tables.sql b/sql/tables.sql index 9126c629..d13eee6e 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -186,9 +186,6 @@ CREATE TRIGGER place_before_delete BEFORE DELETE ON place CREATE TRIGGER place_before_insert BEFORE INSERT ON place FOR EACH ROW EXECUTE PROCEDURE place_insert(); -drop index idx_placex_sector; -CREATE INDEX idx_placex_sector ON placex USING BTREE (geometry_sector,rank_address,osm_type,osm_id) {ts:address-index}; - DROP SEQUENCE seq_postcodes; CREATE SEQUENCE seq_postcodes start 1; -- 2.39.5