# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1536939942 -7200
# Node ID 40d3b697ea154f213c46955c44bc65455d3679eb
# Parent  9ef2f80a4645cd8effb8756f69ace9b496136169
Add PostgreSQL extension for 3D processing

We already use it for cross section calculation (see cross.go).

diff -r 9ef2f80a4645 -r 40d3b697ea15 schema/gemma.sql
--- a/schema/gemma.sql	Fri Sep 14 16:57:12 2018 +0200
+++ b/schema/gemma.sql	Fri Sep 14 17:45:42 2018 +0200
@@ -5,6 +5,9 @@
 --
 CREATE EXTENSION postgis;
 
+-- Needed for 3D processing e.g. for cross section profiles
+CREATE EXTENSION postgis_sfcgal;
+
 -- TODO: will there ever be UPDATEs or can we drop that function due to
 -- historicisation?
 CREATE FUNCTION update_date_info() RETURNS trigger