remove debug code

[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 b97b9103c08a27f8dc68b33a5caff394e8fdda0a..9a31f3ae327c338dc0d1538f68b51e03f1591148 100644 (file)
--- a/lib-sql/functions/placex_triggers.sql
+++ b/lib-sql/functions/placex_triggers.sql
@@ -17,7 +17,6 @@ BEGIN
   -- For POI nodes, check if the address should be derived from a surrounding
   -- building.
   IF p.rank_search < 30 OR p.osm_type != 'N' OR p.address is not null THEN
   -- For POI nodes, check if the address should be derived from a surrounding
   -- building.
   IF p.rank_search < 30 OR p.osm_type != 'N' OR p.address is not null THEN

-    RAISE WARNING 'self address for % %', p.osm_type, p.osm_id;

     address := p.address;
   ELSE
     -- The additional && condition works around the misguided query
     address := p.address;
   ELSE
     -- The additional && condition works around the misguided query


@@ -30,7 +29,6 @@ BEGIN
            and (placex.address ? 'housenumber' or placex.address ? 'street' or placex.address ? 'place')
            and rank_search = 30 AND ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon')
      LIMIT 1;
            and (placex.address ? 'housenumber' or placex.address ? 'street' or placex.address ? 'place')
            and rank_search = 30 AND ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon')
      LIMIT 1;

-    RAISE WARNING 'other address for % %: % (%)', p.osm_type, p.osm_id, address, p.centroid;

   END IF;
 
   address := address - '_unlisted_place'::TEXT;
   END IF;
 
   address := address - '_unlisted_place'::TEXT;