# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1585727843 -7200
# Node ID 1cb5fca140e2608d97f4793afc6b349d5ebf64ef
# Parent  f11b9b50fcc98de5264905499638d2772e9c59d6
Avoid unnecessary trigger executions

diff -r f11b9b50fcc9 -r 1cb5fca140e2 schema/updates/1437/01.historicise_fairway_dimensions.sql
--- 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