Mercurial > gemma
comparison schema/gemma.sql @ 659:ef658c66cfca
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 |