[postgis-tickets] [SCM] PostGIS branch master updated. eacf0c5188d99738840644de779b8fc26e1df999

[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  eacf0c5188d99738840644de779b8fc26e1df999 (commit)
      from  6fbed378759eeec90413a372030e7312a6a66ea8 (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 eacf0c5188d99738840644de779b8fc26e1df999
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Nov 18 17:31:19 2019 -0500

    Don't try to set schema on extensions that have a schema specified (postgis_topology, postgis_tiger_geocoder).  References #4581

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index ae44b60..c154fe9 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -2852,7 +2852,7 @@ BEGIN
 				 -- TODO: How do we tell if PostGIS Tiger Geocoder is available  ?
 			THEN
 				--force install in same schema as postgis only if postgis extension is installed
-				IF rec.name != 'postgis' AND EXISTS (SELECT 1 FROM pg_catalog.pg_extension WHERE extname = 'postgis') THEN
+				IF rec.name NOT IN('postgis', 'postgis_topology', 'postgis_tiger_geocoder') AND EXISTS (SELECT 1 FROM pg_catalog.pg_extension WHERE extname = 'postgis') THEN
 					sql = 'CREATE EXTENSION ' || rec.name || ' FROM unpackaged SCHEMA ' 
 					|| quote_ident( (SELECT ns.nspname FROM pg_catalog.pg_extension AS e INNER JOIN pg_catalog.pg_namespace AS ns ON e.extnamespace = ns.oid WHERE extname = 'postgis')) || ';';
 				ELSE

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

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


hooks/post-receive
-- 
PostGIS