[postgis-tickets] [SCM] PostGIS branch stable-3.0 updated. 3.0.8-3-g400317a3c

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, stable-3.0 has been updated
       via  400317a3cb36c77c94bc61e0709b5744fef0bbfe (commit)
      from  53e96cb16df49a09b7326db9d4531bb47c527eaa (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 400317a3cb36c77c94bc61e0709b5744fef0bbfe
Author: Regina Obe <lr at pcorp.us>
Date:   Wed Feb 15 01:58:52 2023 -0500

    Dump/Restore of raster table fails on
    enforce_coverage_tile_rast constraint
    
    Closes #5338 for PostGIS 3.0.9

diff --git a/NEWS b/NEWS
index 9e3a6ef13..d5ead5c73 100644
--- a/NEWS
+++ b/NEWS
@@ -2,6 +2,8 @@ PostGIS 3.0.9dev
 xxxx/xx/xx
 
 * Bug Fixes *
+  - #5338, Dump/Restore of raster table fails on
+  		     enforce_coverage_tile_rast constraint (Regina Obe)
 
 PostGIS 3.0.8
 2022/11/11
diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in
index 7da88f48f..40f0f6943 100644
--- a/raster/rt_pg/rtpostgis.sql.in
+++ b/raster/rt_pg/rtpostgis.sql.in
@@ -6215,7 +6215,7 @@ CREATE OR REPLACE FUNCTION st_samealignment(
 	ulx2 double precision, uly2 double precision, scalex2 double precision, scaley2 double precision, skewx2 double precision, skewy2 double precision
 )
 	RETURNS boolean
-	AS $$ SELECT st_samealignment(st_makeemptyraster(1, 1, $1, $2, $3, $4, $5, $6), st_makeemptyraster(1, 1, $7, $8, $9, $10, $11, $12)) $$
+	AS $$ SELECT @extschema at .st_samealignment(@extschema at .st_makeemptyraster(1, 1, $1, $2, $3, $4, $5, $6), @extschema at .st_makeemptyraster(1, 1, $7, $8, $9, $10, $11, $12)) $$
 	LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
 
 -- Availability: 2.1.0
@@ -6290,16 +6290,16 @@ CREATE OR REPLACE FUNCTION st_iscoveragetile(rast raster, coverage raster, tilew
 		tile integer[];
 		edge integer[];
 	BEGIN
-		IF NOT ST_SameAlignment(rast, coverage) THEN
+		IF NOT @extschema at .ST_SameAlignment(rast, coverage) THEN
 			RAISE NOTICE 'Raster and coverage are not aligned';
 			RETURN FALSE;
 		END IF;
 
-		_rastmeta := ST_Metadata(rast);
-		_covmeta := ST_Metadata(coverage);
+		_rastmeta := @extschema at .ST_Metadata(rast);
+		_covmeta := @extschema at .ST_Metadata(coverage);
 
 		-- get coverage grid coordinates of upper-left of rast
-		cr := ST_WorldToRasterCoord(coverage, _rastmeta.upperleftx, _rastmeta.upperlefty);
+		cr := @extschema at .ST_WorldToRasterCoord(coverage, _rastmeta.upperleftx, _rastmeta.upperlefty);
 
 		-- rast is not part of coverage
 		IF

-----------------------------------------------------------------------

Summary of changes:
 NEWS                          |  2 ++
 raster/rt_pg/rtpostgis.sql.in | 10 +++++-----
 2 files changed, 7 insertions(+), 5 deletions(-)


hooks/post-receive
-- 
PostGIS