Mercurial > gemma
changeset 5145:1cb5fca140e2
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