X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/181e238b555ec9962e3fc3045d365a39eab06b36..cc17aa8d6b173351c26ead51507499cb8b481a4b:/sql/update-postcodes.sql?ds=sidebyside

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;