Mercurial > gemma

comparison schema/gemma.sql @ 659:ef658c66cfca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
schema: disable sfcgal * Comment out sfcgal extension because it is not available on Ubuntu LTS right now and the setup script will stop completely.
author Bernhard Reiter <bernhard@intevation.de>
date Mon, 17 Sep 2018 16:25:44 +0200
parents 40d3b697ea15
children f595b3455d75
comparison
equal deleted inserted replaced
658:288c496eca26 659:ef658c66cfca
4 -- Infrastructure 4 -- Infrastructure
5 -- 5 --
6 CREATE EXTENSION postgis; 6 CREATE EXTENSION postgis;
7 7
8 -- Needed for 3D processing e.g. for cross section profiles 8 -- Needed for 3D processing e.g. for cross section profiles
9 CREATE EXTENSION postgis_sfcgal; 9 -- FIXME disabled for now, because not available on Ubuntu/Debian
10 --CREATE EXTENSION postgis_sfcgal;
10 11
11 -- TODO: will there ever be UPDATEs or can we drop that function due to 12 -- TODO: will there ever be UPDATEs or can we drop that function due to
12 -- historicisation? 13 -- historicisation?
13 CREATE FUNCTION update_date_info() RETURNS trigger 14 CREATE FUNCTION update_date_info() RETURNS trigger
14 LANGUAGE plpgsql 15 LANGUAGE plpgsql