From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 12 May 2022 09:08:29 +0000 (+0200)
Subject: Merge pull request #2710 from lonvia/offline-import-mode
X-Git-Tag: v4.1.0~41
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/ab71f17c47ca056c88412b896d78cf013b30948e?hp=f314abcfe1203a95073220357f135fa3c69210fc

Merge pull request #2710 from lonvia/offline-import-mode

Assorted performance improvements for BDD tests
---

diff --git a/lib-sql/functions/utils.sql b/lib-sql/functions/utils.sql
index d7fdae3d..ad262670 100644
--- a/lib-sql/functions/utils.sql
+++ b/lib-sql/functions/utils.sql
@@ -170,15 +170,6 @@ BEGIN
 
 -- RAISE WARNING 'near osm fallback: %', ST_AsText(place_centre);
 
-  -- 
-  FOR nearcountry IN
-    SELECT country_code from country_osm_grid
-    WHERE st_dwithin(geometry, place_centre, 0.5)
-    ORDER BY st_distance(geometry, place_centre) asc, area asc limit 1
-  LOOP
-    RETURN nearcountry.country_code;
-  END LOOP;
-
   RETURN NULL;
 END;
 $$