changeset 824:6e5a0edba363

Fixed database function.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 18 Dec 2015 17:32:30 +0100
parents 5155b0b375cd
children e49494d97437
files db_schema/lada_schema.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Thu Dec 03 12:01:27 2015 +0100
+++ b/db_schema/lada_schema.sql	Fri Dec 18 17:32:30 2015 +0100
@@ -152,7 +152,7 @@
         NEW.tree_modified = now();
         RAISE NOTICE 'updating other rows';
         UPDATE land.messung SET tree_modified = now() WHERE probe_id = NEW.id;
-        UPDATE land.ort SET tree_modified = now() WHERE probe_id = NEW.id;
+        UPDATE land.ortszuordnung SET tree_modified = now() WHERE probe_id = NEW.id;
         UPDATE land.zusatz_wert SET tree_modified = now() WHERE probe_id = NEW.id;
         RETURN NEW;
     END;
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)