Mercurial > gemma

changeset 2172:7e2c77ccc02f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Removed trigger to update date_info on gauge_measurements. The date info can be explicitly set by imported data, e.g. in approved gauge measurements. Overwriting this provided data seems wrong...
author Sascha Wilde <wilde@intevation.de>
date Fri, 08 Feb 2019 17:55:42 +0100
parents 543b5d071a69
children 1b1cb6cbfbf0
files schema/gemma.sql
diffstat 1 files changed, 2 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Feb 08 16:52:18 2019 +0100
+++ b/schema/gemma.sql	Fri Feb 08 17:55:42 2019 +0100
@@ -4,13 +4,14 @@
 -- SPDX-License-Identifier: AGPL-3.0-or-later
 -- License-Filename: LICENSES/AGPL-3.0.txt
 
--- Copyright (C) 2018 by via donau
+-- Copyright (C) 2018,2019 by via donau
 --   – Österreichische Wasserstraßen-Gesellschaft mbH
 -- Software engineering by Intevation GmbH
 
 -- Author(s):
 --  * Tom Gottfried <tom@intevation.de>
 --  * Sascha Teichmann <sascha.teichmann@intevation.de>
+--  * Sascha Wilde <sascha.wilde@intevation.de>
 
 BEGIN;
 
@@ -292,9 +293,6 @@
         -- a non-staged fk_gauge_id/measure_date pair.
         UNIQUE (fk_gauge_id, measure_date, staging_done)
     )
-    CREATE TRIGGER gauge_measurements_date_info
-        BEFORE UPDATE ON gauge_measurements
-        FOR EACH ROW EXECUTE PROCEDURE update_date_info()
 
     CREATE TABLE waterway_axis (
         id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,