Mercurial > gemma

annotate schema/updates/1431/01.prevent_equal_fairway_areas.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents e21cbb9768a2
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5095
e21cbb9768a2 Prevent duplicate fairway areas
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 CREATE CONSTRAINT TRIGGER fairway_dimensions_area_unique
e21cbb9768a2 Prevent duplicate fairway areas
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 AFTER INSERT OR UPDATE OF area, staging_done
e21cbb9768a2 Prevent duplicate fairway areas
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 ON waterway.fairway_dimensions
e21cbb9768a2 Prevent duplicate fairway areas
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 FOR EACH ROW EXECUTE FUNCTION prevent_st_equals('area', 'staging_done');