[postgis-tickets] r15117 - missed another schema qualify

[Regina Obe]

Author: robe
Date: 2016-09-18 21:00:29 -0700 (Sun, 18 Sep 2016)
New Revision: 15117

Modified:
   trunk/raster/rt_pg/rtpostgis.sql.in
Log:
missed another schema qualify

Modified: trunk/raster/rt_pg/rtpostgis.sql.in
===================================================================
--- trunk/raster/rt_pg/rtpostgis.sql.in	2016-09-19 03:42:33 UTC (rev 15116)
+++ trunk/raster/rt_pg/rtpostgis.sql.in	2016-09-19 04:00:29 UTC (rev 15117)
@@ -7202,7 +7202,7 @@
 
 		cn := 'enforce_same_alignment_' || $3;
 
-		sql := 'SELECT st_makeemptyraster(1, 1, upperleftx, upperlefty, scalex, scaley, skewx, skewy, srid) FROM st_metadata((SELECT '
+		sql := 'SELECT @extschema at .st_makeemptyraster(1, 1, upperleftx, upperlefty, scalex, scaley, skewx, skewy, srid) FROM @extschema at .st_metadata((SELECT '
 			|| quote_ident($3)
 			|| ' FROM ' || fqtn || ' LIMIT 1))';
 		BEGIN
@@ -7342,7 +7342,7 @@
 
 		-- metadata
 		BEGIN
-			sql := 'WITH foo AS (SELECT ST_Metadata(' || quote_ident($3) || ') AS meta, ST_ConvexHull(' || quote_ident($3) || ') AS hull FROM ' || fqtn || ') SELECT max((meta).scalex), max((meta).scaley), max((meta).skewx), max((meta).skewy), max((meta).width), max((meta).height), ST_Union(hull) FROM foo';
+			sql := 'WITH foo AS (SELECT @extschema at .ST_Metadata(' || quote_ident($3) || ') AS meta, @extschema at .ST_ConvexHull(' || quote_ident($3) || ') AS hull FROM ' || fqtn || ') SELECT max((meta).scalex), max((meta).scaley), max((meta).skewx), max((meta).skewy), max((meta).width), max((meta).height), @extschema at .ST_Union(hull) FROM foo';
 			EXECUTE sql INTO _scalex, _scaley, _skewx, _skewy, _tilewidth, _tileheight, _covextent;
 		EXCEPTION WHEN OTHERS THEN
 			RAISE DEBUG 'Unable to get coverage metadata for %.%: % (%)',
@@ -7352,7 +7352,7 @@
 
 		-- rasterize extent
 		BEGIN
-			_covrast := ST_AsRaster(_covextent, _scalex, _scaley, '8BUI', 1, 0, NULL, NULL, _skewx, _skewy);
+			_covrast := @extschema at .ST_AsRaster(_covextent, _scalex, _scaley, '8BUI', 1, 0, NULL, NULL, _skewx, _skewy);
 			IF _covrast IS NULL THEN
 				RAISE NOTICE 'Unable to create coverage raster. Cannot add coverage tile constraint: % (%)',
           SQLERRM, SQLSTATE;
@@ -7441,7 +7441,7 @@
 
 		cn := 'enforce_num_bands_' || $3;
 
-		sql := 'SELECT st_numbands(' || quote_ident($3)
+		sql := 'SELECT @extschema at .st_numbands(' || quote_ident($3)
 			|| ') FROM ' || fqtn
 			|| ' LIMIT 1';
 		BEGIN
@@ -7454,7 +7454,7 @@
 
 		sql := 'ALTER TABLE ' || fqtn
 			|| ' ADD CONSTRAINT ' || quote_ident(cn)
-			|| ' CHECK (st_numbands(' || quote_ident($3)
+			|| ' CHECK (@extschema at .st_numbands(' || quote_ident($3)
 			|| ') = ' || attr
 			|| ')';
 		RETURN  @extschema at ._add_raster_constraint(cn, sql);
@@ -7703,7 +7703,7 @@
 
 		sql := 'ALTER TABLE ' || fqtn
 			|| ' ADD CONSTRAINT ' || quote_ident(cn)
-			|| ' CHECK (_raster_constraint_out_db(' || quote_ident($3)
+			|| ' CHECK ( @extschema at ._raster_constraint_out_db(' || quote_ident($3)
 			|| ') = ''{';
 		FOR x in 1..max LOOP
 			IF attr[x] IS FALSE THEN