From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 12 Oct 2017 19:03:03 +0000 (+0200)
Subject: take country names only from relations
X-Git-Tag: v3.1.0~44
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/7ea1ef3feb587b58f74784e6802c2e74d90e22cc

take country names only from relations
---

diff --git a/sql/functions.sql b/sql/functions.sql
index a9bca542..596bf808 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1757,7 +1757,7 @@ BEGIN
   END IF;
 
   -- make sure all names are in the word table
-  IF NEW.admin_level = 2 AND NEW.class = 'boundary' AND NEW.type = 'administrative' AND NEW.country_code IS NOT NULL THEN
+  IF NEW.admin_level = 2 AND NEW.class = 'boundary' AND NEW.type = 'administrative' AND NEW.country_code IS NOT NULL AND NEW.osm_type = 'R' THEN
     perform create_country(NEW.name, lower(NEW.country_code));
     --DEBUG: RAISE WARNING 'Country names updated';
   END IF;