From 3001d975f742f02dcd720943a5588155cdc72e8b Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 7 Nov 2018 15:37:42 +0000 Subject: [PATCH] Add missing schema qualifications for raster _ST_Intersects references #4129 for PostGIS 3.0 git-svn-id: http://svn.osgeo.org/postgis/trunk@16988 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/rt_pg/rtpostgis.sql.in | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in index 36006a8f9..2ac585cba 100644 --- a/raster/rt_pg/rtpostgis.sql.in +++ b/raster/rt_pg/rtpostgis.sql.in @@ -6417,18 +6417,18 @@ CREATE OR REPLACE FUNCTION _st_intersects(geom geometry, rast raster, nband inte RETURNS boolean AS $$ DECLARE hasnodata boolean := TRUE; - _geom geometry; + _geom @extschema@.geometry; BEGIN - IF ST_SRID(rast) != ST_SRID(geom) THEN + IF @extschema@.ST_SRID(rast) != @extschema@.ST_SRID(geom) THEN RAISE EXCEPTION 'Raster and geometry do not have the same SRID'; END IF; - _geom := ST_ConvexHull(rast); + _geom := @extschema@.ST_ConvexHull(rast); IF nband IS NOT NULL THEN SELECT CASE WHEN bmd.nodatavalue IS NULL THEN FALSE ELSE NULL END INTO hasnodata FROM @extschema@.ST_BandMetaData(rast, nband) AS bmd; END IF; - IF ST_Intersects(geom, _geom) IS NOT TRUE THEN + IF @extschema@.ST_Intersects(geom, _geom) IS NOT TRUE THEN RETURN FALSE; ELSEIF nband IS NULL OR hasnodata IS FALSE THEN RETURN TRUE; -- 2.40.0