Mercurial > gemma
view schema/updates/1429/01.disallow_empty_fairway_dimensions.sql @ 5560:f2204f91d286
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 | 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)))