Mercurial > gemma

comparison schema/gemma.sql @ 657:40d3b697ea15

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add PostgreSQL extension for 3D processing We already use it for cross section calculation (see cross.go).
author Tom Gottfried <tom@intevation.de>
date Fri, 14 Sep 2018 17:45:42 +0200
parents 9ef2f80a4645
children ef658c66cfca
comparison
equal deleted inserted replaced
656:9ef2f80a4645 657:40d3b697ea15
2 2
3 -- 3 --
4 -- Infrastructure 4 -- Infrastructure
5 -- 5 --
6 CREATE EXTENSION postgis; 6 CREATE EXTENSION postgis;
7
8 -- Needed for 3D processing e.g. for cross section profiles
9 CREATE EXTENSION postgis_sfcgal;
7 10
8 -- TODO: will there ever be UPDATEs or can we drop that function due to 11 -- TODO: will there ever be UPDATEs or can we drop that function due to
9 -- historicisation? 12 -- historicisation?
10 CREATE FUNCTION update_date_info() RETURNS trigger 13 CREATE FUNCTION update_date_info() RETURNS trigger
11 LANGUAGE plpgsql 14 LANGUAGE plpgsql