From b2832205ccc23705a39e4bad84605c83f47ea98a Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 1 Aug 2012 03:47:18 +0000 Subject: [PATCH] Fix raise notice that only shows in debug mode git-svn-id: http://svn.osgeo.org/postgis/trunk@10149 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql b/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql index 86517b3a5..038466a5a 100644 --- a/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql +++ b/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql @@ -214,8 +214,9 @@ BEGIN IF var_debug THEN RAISE NOTICE 'Replaced with : %, %', var_addy_alt, clock_timestamp(); END IF; - END IF; - IF var_debug THEN + END IF; + + IF var_debug THEN RAISE NOTICE 'End Get matching edges loop: %', clock_timestamp(); RAISE NOTICE 'Final addresses: %, %', addy, clock_timestamp(); END IF; @@ -229,7 +230,7 @@ BEGIN IF NOT FOUND THEN addy := array_append(addy,var_addy); IF var_debug THEN - RAISE NOTICE 'No address found: adding: % street: %, %', addy, var_addy, var_addy.streetname, clock_timestamp(); + RAISE NOTICE 'No address found: adding: % street: %, %', var_addy, var_addy.streetname, clock_timestamp(); END IF; END IF; IF var_debug THEN -- 2.40.0