X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/c2629bc08d081262a7fd1cbd9d52acb5f44bd8ec..503f9d19f19ded024e77e62cddb1d2a22bcac102:/sql/update-postcodes.sql

diff --git a/sql/update-postcodes.sql b/sql/update-postcodes.sql
index a90abe25..1cbc8858 100644
--- a/sql/update-postcodes.sql
+++ b/sql/update-postcodes.sql
@@ -48,5 +48,11 @@ INSERT INTO location_postcode
   SELECT nextval('seq_place'), 1, country_code, pc, centroid
     FROM tmp_new_postcode_locations new;
 
+-- Remove unused word entries
+DELETE FROM word
+    WHERE class = 'place' AND type = 'postcode'
+          AND NOT EXISTS (SELECT 0 FROM location_postcode p
+                          WHERE p.postcode = word.word);
+
 -- Finally index the newly inserted postcodes
 UPDATE location_postcode SET indexed_status = 0 WHERE indexed_status > 0;