From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 2 Jul 2017 14:28:02 +0000 (+0200)
Subject: make sure postcode gets recomputed on update
X-Git-Tag: v3.1.0~88^2~29
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/43869b9938a25f87481d6ecd0654906a9627e7aa

make sure postcode gets recomputed on update
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 573e80e7..1c4fbb64 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1272,6 +1272,7 @@ BEGIN
   -- cheaper but less acurate
   place_centroid := ST_PointOnSurface(NEW.geometry);
   NEW.centroid := null;
+  NEW.postcode := null;
   --DEBUG: RAISE WARNING 'Computing preliminary centroid at %',ST_AsText(place_centroid);
 
   -- recalculate country and partition
@@ -1512,7 +1513,7 @@ BEGIN
       IF NEW.address is not null AND NEW.address ? 'postcode' THEN
           NEW.postcode = NEW.address->'postcode';
       ELSE
-         SELECT postcode FROM placex WHERE place_id = parent_place_id INTO NEW.postcode;
+         SELECT postcode FROM placex WHERE place_id = NEW.parent_place_id INTO NEW.postcode;
       END IF;
       IF NEW.postcode is null THEN
         NEW.postcode := get_nearest_postcode(NEW.country_code, place_centroid);