X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/bafbf679b62d440894656601a980cc93474f2a5e..abd294912abf844d054d5786dd80b7f1a2170a4d:/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;
