disable country name updates

[nominatim.git] / lib-sql / functions / placex_triggers.sql

diff --git a/lib-sql/functions/placex_triggers.sql b/lib-sql/functions/placex_triggers.sql
index 6ab73a3b4143dea539d7304ce8cc464d2109e7a5..3755a11f60e8b0b2194f7258e7f83730ffacc69a 100644 (file)
--- a/lib-sql/functions/placex_triggers.sql
+++ b/lib-sql/functions/placex_triggers.sql
@@ -1047,14 +1047,14 @@ BEGIN
     -- Update the list of country names. Adding an additional sanity
     -- check here: make sure the country does overlap with the area where
     -- we expect it to be as per static country grid.
-    FOR location IN
-      SELECT country_code FROM country_osm_grid
-       WHERE ST_Covers(geometry, NEW.centroid) and country_code = NEW.country_code
-       LIMIT 1
-    LOOP
-      {% if debug %}RAISE WARNING 'Updating names for country '%' with: %', NEW.country_code, NEW.name;{% endif %}
-      UPDATE country_name SET name = name || NEW.name WHERE country_code = NEW.country_code;
-    END LOOP;
+    -- FOR location IN
+    --  SELECT country_code FROM country_osm_grid
+    --   WHERE ST_Covers(geometry, NEW.centroid) and country_code = NEW.country_code
+    --   LIMIT 1
+    -- LOOP
+    --  {% if debug %}RAISE WARNING 'Updating names for country '%' with: %', NEW.country_code, NEW.name;{% endif %}
+    --  UPDATE country_name SET name = name || NEW.name WHERE country_code = NEW.country_code;
+    -- END LOOP;
   END IF;
 
   -- For linear features we need the full geometry for determining the address