Mercurial > gemma
view schema/updates/1431/01.prevent_equal_fairway_areas.sql @ 5721:0500d76e074b uploadwg
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');