From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 3 Jul 2019 18:56:35 +0000 (+0200)
Subject: Reset housenumber on every place update
X-Git-Tag: v3.4.0~29
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/d1ca73f813465de8102f79ac71dbe71d8ba320da

Reset housenumber on every place update

As it is a computed field, it needs to be computed from scratch
to take into account any surrounding changes.

Fixes #1395.
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 0cfeaf0c..2b399875 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1230,6 +1230,8 @@ BEGIN
   END IF;
 
   --DEBUG: RAISE WARNING 'Copy over address tags';
+  -- housenumber is a computed field, so start with an empty value
+  NEW.housenumber := NULL;
   IF NEW.address is not NULL THEN
       IF NEW.address ? 'conscriptionnumber' THEN
         i := getorcreate_housenumber_id(make_standard_name(NEW.address->'conscriptionnumber'));