diff db_schema/lada_schema.sql @ 824:6e5a0edba363

Fixed database function.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 18 Dec 2015 17:32:30 +0100
parents 2b0d99fbeecc
children 47dc3c4e42dd
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)