Mercurial > gemma

changeset 5145:1cb5fca140e2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Avoid unnecessary trigger executions
author Tom Gottfried <tom@intevation.de>
date Wed, 01 Apr 2020 09:57:23 +0200
parents f11b9b50fcc9
children 265265725277
files schema/updates/1437/01.historicise_fairway_dimensions.sql
diffstat 1 files changed, 3 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/updates/1437/01.historicise_fairway_dimensions.sql	Tue Mar 31 18:59:28 2020 +0200
+++ b/schema/updates/1437/01.historicise_fairway_dimensions.sql	Wed Apr 01 09:57:23 2020 +0200
@@ -1,3 +1,6 @@
+-- Drop trigger first to avoid execution during following operations
+DROP TRIGGER fairway_dimensions_area_unique ON waterway.fairway_dimensions;
+
 ALTER TABLE waterway.fairway_dimensions
     ADD validity tstzrange NOT NULL DEFAULT tstzrange(current_timestamp, NULL)
         CHECK (NOT isempty(validity));
@@ -19,7 +22,6 @@
         current_timestamp),
     NULL);
 
-DROP TRIGGER fairway_dimensions_area_unique ON waterway.fairway_dimensions;
 CREATE CONSTRAINT TRIGGER fairway_dimensions_area_unique
     AFTER INSERT OR UPDATE OF area, validity, staging_done
     ON waterway.fairway_dimensions