From: Brian Quinion <openstreetmap@brian.quinion.co.uk>
Date: Tue, 22 May 2012 18:25:18 +0000 (+0200)
Subject: can't have a unique index on placex - only on place
X-Git-Tag: v2.0.0~65
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/c36e3d9c7ea9f0fe61377c0769e14d1c8e90f45a

can't have a unique index on placex - only on place
---

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index 4db5a104..e94ea0ee 100644
--- a/sql/indices.src.sql
+++ b/sql/indices.src.sql
@@ -28,5 +28,4 @@ CREATE INDEX idx_search_name_country_nameaddress_vector ON search_name_country U
 CREATE INDEX idx_location_property_-partition-_centroid ON location_property_-partition- USING GIST (centroid);
 -- end
 
-CREATE UNIQUE INDEX idx_placex_osm_unique on placex using btree(osm_id,osm_type,class,type);
 CREATE UNIQUE INDEX idx_place_osm_unique on place using btree(osm_id,osm_type,class,type);