[postgis-tickets] [SCM] PostGIS branch master updated. 7613d9ae7af8144043dad3e42131a881142e17f0

[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, master has been updated
       via  7613d9ae7af8144043dad3e42131a881142e17f0 (commit)
      from  8625813329c8c6be963bdca48657629c45f68c26 (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 7613d9ae7af8144043dad3e42131a881142e17f0
Author: Regina Obe <lr at pcorp.us>
Date:   Sun Nov 17 14:02:54 2019 -0500

    postgis_raster installed from unpackaged needs to specify schema of postgis. References #4581 for master PostGIS 3.1

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index e3c93a1..b29db3b 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -2804,6 +2804,7 @@ AS $$
 $$ LANGUAGE 'sql' STABLE;
 
 -- Availability: 2.5.0
+-- Changed: 3.0.1 install from unpackaged should include postgis schema #4581
 -- Changed: 3.0.0 also upgrade postgis_raster if it exists
 CREATE OR REPLACE FUNCTION postgis_extensions_upgrade() RETURNS text
 AS $$
@@ -2850,7 +2851,7 @@ BEGIN
 
 				 -- TODO: How do we tell if PostGIS Tiger Geocoder is available  ?
 			THEN
-				sql = 'CREATE EXTENSION ' || rec.name || ' FROM unpackaged';
+				sql = 'CREATE EXTENSION ' || rec.name || ' FROM unpackaged SCHEMA @extschema@';
 				RAISE NOTICE 'Packaging extension %', rec.name;
 				RAISE DEBUG '%', sql;
 				EXECUTE sql;

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

Summary of changes:
 postgis/postgis.sql.in | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS