diff db_schema/stammdaten_schema.sql @ 1249:f094aca05cf2

Avoid having to handle missing shapes.
author Tom Gottfried <tom@intevation.de>
date Fri, 16 Dec 2016 16:18:37 +0100
parents 9b8b18c00804
children cb88ab44c2be
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Fri Dec 16 14:00:16 2016 +0100
+++ b/db_schema/stammdaten_schema.sql	Fri Dec 16 16:18:37 2016 +0100
@@ -167,7 +167,7 @@
 CREATE TABLE verwaltungsgrenze (
     id serial PRIMARY KEY,
     gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit,
-    shape public.geometry(MultiPolygon, 4326)
+    shape public.geometry(MultiPolygon, 4326) NOT NULL
 );
 CREATE INDEX verwaltungsgrenze_sp_idx ON verwaltungsgrenze USING gist (shape);
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)