From 9ad08062a092830000882d9ad8d80f501452dbad Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Wed, 7 Sep 2016 18:15:24 +0000 Subject: [PATCH] Fix schema support in RT_CreateOveriew Patch by hypostase Closes #3615 git-svn-id: http://svn.osgeo.org/postgis/trunk@15078 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/rt_pg/rtpostgis.sql.in | 3 ++- raster/test/regress/rt_createoverview.sql | 5 +++++ raster/test/regress/rt_createoverview_expected | 1 + 3 files changed, 8 insertions(+), 1 deletion(-) diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in index a5aba3b61..99d1f5d9b 100644 --- a/raster/rt_pg/rtpostgis.sql.in +++ b/raster/rt_pg/rtpostgis.sql.in @@ -8775,7 +8775,8 @@ BEGIN PERFORM @extschema@.AddOverviewConstraints(sinfo.sch, ttab, col, sinfo.sch, sinfo.tab, col, factor); - RETURN ttab; + -- return the schema as well as the table + RETURN sinfo.sch||'.'||ttab; END; $$ LANGUAGE 'plpgsql' VOLATILE STRICT; diff --git a/raster/test/regress/rt_createoverview.sql b/raster/test/regress/rt_createoverview.sql index 3cc172ca0..c73119c34 100644 --- a/raster/test/regress/rt_createoverview.sql +++ b/raster/test/regress/rt_createoverview.sql @@ -1,4 +1,7 @@ SET client_min_messages TO warning; + +CREATE SCHEMA oschm; +SET search_path TO oschm,public; CREATE TABLE res1 AS SELECT ST_AddBand( ST_MakeEmptyRaster(10, 10, x, y, 1, -1, 0, 0, 0) @@ -52,3 +55,5 @@ DROP TABLE o_8_res1; DROP TABLE o_4_res1; DROP TABLE o_2_res1; DROP TABLE res1; +DROP SCHEMA oschm; +DISCARD ALL; -- resets change in search_path diff --git a/raster/test/regress/rt_createoverview_expected b/raster/test/regress/rt_createoverview_expected index 7173bcaa5..8e2d4ea8e 100644 --- a/raster/test/regress/rt_createoverview_expected +++ b/raster/test/regress/rt_createoverview_expected @@ -13,3 +13,4 @@ o_4_res1|r|res1|r|4 o_8_res1|r|res1|r|8 o_16_res1|r|res1|r|16 count|544|136|36|10|3 +DISCARD ALL -- 2.40.0