X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/2419066aabea73f78c4f21420b26bc0c633998e7..d68a6a4942d27d820c2ce31e122b896ccbb4d1db:/sql/functions.sql diff --git a/sql/functions.sql b/sql/functions.sql index 5d2b7a22..43ab4fff 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -2020,7 +2020,7 @@ BEGIN IF ST_IsEmpty(NEW.geometry) OR NOT ST_IsValid(NEW.geometry) OR ST_X(ST_Centroid(NEW.geometry))::text in ('NaN','Infinity','-Infinity') OR ST_Y(ST_Centroid(NEW.geometry))::text in ('NaN','Infinity','-Infinity') THEN INSERT INTO import_polygon_error (osm_type, osm_id, class, type, name, country_code, updated, errormessage, prevgeometry, newgeometry) VALUES (NEW.osm_type, NEW.osm_id, NEW.class, NEW.type, NEW.name, NEW.address->'country', now(), ST_IsValidReason(NEW.geometry), null, NEW.geometry); --- RAISE WARNING 'Invalid Geometry: % % % %',NEW.osm_type,NEW.osm_id,NEW.class,NEW.type; + RAISE WARNING 'Invalid Geometry: % % % %',NEW.osm_type,NEW.osm_id,NEW.class,NEW.type; RETURN null; END IF;