Mercurial > gemma
changeset 4882:566e9ee70d45
Backout changesets 5c12b7cdc58c and 8a4c98b80fbd
Usefulness for dump/restore could not be approved in further tests.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 31 Jan 2020 15:48:52 +0100 |
parents | 9f1c33ba3f0a |
children | 7878a1cde024 638a61fb881b |
files | schema/gemma.sql |
diffstat | 1 files changed, 1 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Fri Jan 31 13:38:08 2020 +0100 +++ b/schema/gemma.sql Fri Jan 31 15:48:52 2020 +0100 @@ -27,7 +27,6 @@ -- -- Check if a given string can be used as a FROM item in an SQL statement --- All objects in stmt should be schema qualified if not in the public schema CREATE OR REPLACE FUNCTION is_valid_from_item(stmt text) RETURNS boolean AS $$ BEGIN @@ -39,7 +38,6 @@ RETURN false; END $$ - SET search_path TO 'public' LANGUAGE plpgsql STRICT; @@ -231,7 +229,7 @@ LANGUAGE plpgsql AS $$ BEGIN - IF NOT public.ST_Intersects((SELECT area + IF NOT st_intersects((SELECT area FROM waterway.bottlenecks WHERE bottleneck_id = NEW.bottleneck_id AND validity @> NEW.date_info::timestamptz),