reintroduce index on gb_postcode

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index f715df8d6fd4bb3c7575d4d3aebb0941c0d614f2..6e9c293e96f58cab4f99e16b87f4d6ee4ce51453 100644 (file)
--- a/sql/indices.src.sql
+++ b/sql/indices.src.sql
@@ -28,3 +28,6 @@ CREATE INDEX idx_location_property_-partition-_centroid ON location_property_-pa
 -- end
 
 CREATE UNIQUE INDEX idx_place_osm_unique on place using btree(osm_id,osm_type,class,type);
 -- end
 
 CREATE UNIQUE INDEX idx_place_osm_unique on place using btree(osm_id,osm_type,class,type);

+
+
+CREATE INDEX idx_gb_postcode_postcode ON gb_postcode USING BTREE (postcode);