Mercurial > gemma

view schema/updates/1429/01.disallow_empty_fairway_dimensions.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 8c590ef35280
children
line wrap: on
line source

ALTER TABLE waterway.fairway_dimensions
    DROP CONSTRAINT fairway_dimensions_area_check,
    ADD CHECK(ST_IsValid(CAST(area AS geometry))
        AND NOT ST_IsEmpty(CAST(area AS geometry)))