Mercurial > gemma

view schema/updates/1431/01.prevent_equal_fairway_areas.sql @ 5721:0500d76e074b uploadwg

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed eraseObsoleteGaugesSQL by reintroducing matching on users CC. The condition was removed when introducing file upload, but that leads to too many gauges being removed.
author Sascha Wilde <wilde@sha-bang.de>
date Fri, 19 Apr 2024 16:52:14 +0200
parents e21cbb9768a2
children
line wrap: on
line source

CREATE CONSTRAINT TRIGGER fairway_dimensions_area_unique
    AFTER INSERT OR UPDATE OF area, staging_done
    ON waterway.fairway_dimensions
    FOR EACH ROW EXECUTE FUNCTION prevent_st_equals('area', 'staging_done');