Mercurial > gemma

comparison schema/gemma.sql @ 931:e758e12b38c9 geo-style

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into geo-style branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 08 Oct 2018 14:48:58 +0200
parents 688e1530f66a 71445b091415
children feef06db5d9d
comparison
equal deleted inserted replaced
929:688e1530f66a 931:e758e12b38c9
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 -- FIXME disabled for now, because not available on Ubuntu/Debian
10 --CREATE EXTENSION postgis_sfcgal;
11 7
12 -- TODO: will there ever be UPDATEs or can we drop that function due to 8 -- TODO: will there ever be UPDATEs or can we drop that function due to
13 -- historicisation? 9 -- historicisation?
14 CREATE FUNCTION update_date_info() RETURNS trigger 10 CREATE FUNCTION update_date_info() RETURNS trigger
15 LANGUAGE plpgsql 11 LANGUAGE plpgsql