Mercurial > lada > lada-server
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;