Mercurial > gemma
comparison schema/gemma.sql @ 5031:8c590ef35280
Improve feedback if geometry cannot be stored
This is also a backout of rev. 36a3dce20232
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 18 Mar 2020 19:19:09 +0100 |
parents | 737d7859dd86 |
children | e21cbb9768a2 f64ff954ee31 |
comparison
equal
deleted
inserted
replaced
5030:737d7859dd86 | 5031:8c590ef35280 |
---|---|
706 FOR EACH ROW EXECUTE PROCEDURE update_date_info() | 706 FOR EACH ROW EXECUTE PROCEDURE update_date_info() |
707 | 707 |
708 CREATE TABLE fairway_dimensions ( | 708 CREATE TABLE fairway_dimensions ( |
709 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, | 709 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, |
710 area geography(MULTIPOLYGON, 4326) NOT NULL | 710 area geography(MULTIPOLYGON, 4326) NOT NULL |
711 CHECK(ST_IsValid(CAST(area AS geometry))), | 711 CHECK(ST_IsValid(CAST(area AS geometry)) |
712 AND NOT ST_IsEmpty(CAST(area AS geometry))), | |
712 level_of_service smallint NOT NULL REFERENCES levels_of_service, | 713 level_of_service smallint NOT NULL REFERENCES levels_of_service, |
713 min_width smallint NOT NULL, | 714 min_width smallint NOT NULL, |
714 max_width smallint NOT NULL, | 715 max_width smallint NOT NULL, |
715 min_depth smallint NOT NULL, | 716 min_depth smallint NOT NULL, |
716 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, | 717 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, |