Mercurial > gemma

diff schema/updates/1460/01.markings.sql @ 5417:2d294ad81241 marking-single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Dont loose Z values in markings.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 07 Jul 2021 18:14:04 +0200
parents f5063fa7f666
children ad8e3fffb868
line wrap: on
line diff
--- a/schema/updates/1460/01.markings.sql	Wed Jul 07 14:57:30 2021 +0200
+++ b/schema/updates/1460/01.markings.sql	Wed Jul 07 18:14:04 2021 +0200
@@ -4,7 +4,7 @@
    sounding_result_id int NOT NULL REFERENCES waterway.sounding_results
      ON DELETE CASCADE,
    height numeric NOT NULL,
-   points geography(MULTIPOINT, 4326) NOT NULL,
+   points geometry(MULTIPOINTZ, 4326) NOT NULL,
    PRIMARY KEY (sounding_result_id, height)
 );