X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/09f4d767e4498368f798d8c1b579b1bf730f4baf..0ec3fdd3bab67abe3c78cadf362fffa250dd7d34:/lib-sql/tables.sql

diff --git a/lib-sql/tables.sql b/lib-sql/tables.sql
index 0895c6dd..329eb7a1 100644
--- a/lib-sql/tables.sql
+++ b/lib-sql/tables.sql
@@ -209,6 +209,7 @@ CREATE TABLE location_postcode (
   postcode TEXT,
   geometry GEOMETRY(Geometry, 4326)
   );
+CREATE UNIQUE INDEX idx_postcode_id ON location_postcode USING BTREE (place_id) {{db.tablespace.search_index}};
 CREATE INDEX idx_postcode_geometry ON location_postcode USING GIST (geometry) {{db.tablespace.address_index}};
 GRANT SELECT ON location_postcode TO "{{config.DATABASE_WEBUSER}}" ;