[postgis-tickets] r16988 - Add missing schema qualifications for raster _ST_Intersects

[Regina Obe]

Author: robe
Date: 2018-11-07 07:37:42 -0800 (Wed, 07 Nov 2018)
New Revision: 16988

Modified:
   trunk/raster/rt_pg/rtpostgis.sql.in
Log:
Add missing schema qualifications for raster _ST_Intersects
references #4129 for PostGIS 3.0

Modified: trunk/raster/rt_pg/rtpostgis.sql.in
===================================================================
--- trunk/raster/rt_pg/rtpostgis.sql.in	2018-11-07 15:08:22 UTC (rev 16987)
+++ trunk/raster/rt_pg/rtpostgis.sql.in	2018-11-07 15:37:42 UTC (rev 16988)
@@ -6417,18 +6417,18 @@
 	RETURNS boolean AS $$
 	DECLARE
 		hasnodata boolean := TRUE;
-		_geom geometry;
+		_geom @extschema at .geometry;
 	BEGIN
-		IF ST_SRID(rast) != ST_SRID(geom) THEN
+		IF @extschema at .ST_SRID(rast) != @extschema at .ST_SRID(geom) THEN
 			RAISE EXCEPTION 'Raster and geometry do not have the same SRID';
 		END IF;
 
-		_geom := ST_ConvexHull(rast);
+		_geom := @extschema at .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 at .ST_BandMetaData(rast, nband) AS bmd;
 		END IF;
 
-		IF ST_Intersects(geom, _geom) IS NOT TRUE THEN
+		IF @extschema at .ST_Intersects(geom, _geom) IS NOT TRUE THEN
 			RETURN FALSE;
 		ELSEIF nband IS NULL OR hasnodata IS FALSE THEN
 			RETURN TRUE;