Mercurial > gemma

changeset 4882:566e9ee70d45

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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),