[postgis-tickets] r17925 - Fix ST_ConcaveHull under FDW

[Raul]

Author: algunenano
Date: 2019-10-17 03:29:15 -0700 (Thu, 17 Oct 2019)
New Revision: 17925

Modified:
   trunk/NEWS
   trunk/postgis/Makefile.in
   trunk/postgis/postgis.sql.in
   trunk/raster/rt_pg/Makefile.in
   trunk/raster/rt_pg/rtpostgis.sql.in
Log:
Fix ST_ConcaveHull under FDW

References #4546
Closes https://github.com/postgis/postgis/pull/497



Modified: trunk/NEWS
===================================================================
--- trunk/NEWS	2019-10-17 05:29:47 UTC (rev 17924)
+++ trunk/NEWS	2019-10-17 10:29:15 UTC (rev 17925)
@@ -10,6 +10,7 @@
 * Bug fixes *
   - #4544, Fix leak when parsing a WKT geometry_list (Raúl Marín)
   - #4545, Fix leak in wkt_parser_triangle_new (Raúl Marín)
+  - #4546, Fix ST_ConcaveHull under FDW (Raúl Marín)
 
 PostGIS 3.0.0rc2
 2019/10/13

Modified: trunk/postgis/Makefile.in
===================================================================
--- trunk/postgis/Makefile.in	2019-10-17 05:29:47 UTC (rev 17924)
+++ trunk/postgis/Makefile.in	2019-10-17 10:29:15 UTC (rev 17925)
@@ -235,7 +235,7 @@
 # replace @extschema at . with nothing, this is only used as placeholder for extension install
 %.sql: %.sql.in
 	$(SQLPP) -I../libpgcommon $< | grep -v '^#' | \
-	$(PERL) -lpe "s'MODULE_PATHNAME'\$(MODULEPATH)'g;s'@extschema@\.''g" > $@
+	$(PERL) -lpe "s'MODULE_PATHNAME'\$(MODULEPATH)'g;s'@extschema@\.''g;s'SET search_path = @extschema@''g;" > $@
 
 #this is redundant but trying to fold in with extension just hangs
 postgis_upgrade.sql.in: postgis.sql ../utils/postgis_proc_upgrade.pl

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2019-10-17 05:29:47 UTC (rev 17924)
+++ trunk/postgis/postgis.sql.in	2019-10-17 10:29:15 UTC (rev 17925)
@@ -5570,7 +5570,7 @@
 
 	geom := @extschema at .ST_BuildArea(mline);
 
-	IF GeometryType(geom) != 'POLYGON'
+	IF @extschema at .GeometryType(geom) != 'POLYGON'
 	THEN
 		RAISE EXCEPTION 'Input returns more then a single polygon, try using BdMPolyFromText instead';
 	END IF;
@@ -5578,7 +5578,8 @@
 	RETURN geom;
 END;
 $$
-LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL;
+LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL
+SET search_path = @extschema@;
 
 --
 -- SFSQL 1.1
@@ -5615,7 +5616,8 @@
 	RETURN geom;
 END;
 $$
-LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL;
+LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL
+SET search_path = @extschema@;
 
 /* Should we include the .sql directly here ? */
 #include "long_xact.sql.in"
@@ -6070,7 +6072,8 @@
 
 	END;
 $$
-LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL _COST_HIGH;
+LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL _COST_HIGH
+SET search_path = @extschema@;
 
 -- Availability: 2.0.0
 -- Changed: 2.5.0
@@ -6232,7 +6235,8 @@
             RETURN var_resultgeom;
 	END;
 $$
-LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL _COST_HIGH;
+LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL _COST_HIGH
+SET search_path = @extschema@;
 -- ST_ConcaveHull and Helper functions end here --
 
 -----------------------------------------------------------------------

Modified: trunk/raster/rt_pg/Makefile.in
===================================================================
--- trunk/raster/rt_pg/Makefile.in	2019-10-17 05:29:47 UTC (rev 17924)
+++ trunk/raster/rt_pg/Makefile.in	2019-10-17 10:29:15 UTC (rev 17925)
@@ -114,7 +114,7 @@
 # replace @extschema at . with nothing, this is only used as placeholder for extension install
 %.sql: %.sql.in
 	$(SQLPP) -I../../postgis/ -I../../ $< | grep -v '^#' | \
-	$(PERL) -lpe "s'MODULE_PATHNAME'\$(MODULEPATH)'g;s'@extschema@\.''g" > $@
+	$(PERL) -lpe "s'MODULE_PATHNAME'\$(MODULEPATH)'g;s'@extschema@\.''g;s'SET search_path = @extschema@''g;" > $@
 
 ../../liblwgeom/.libs/liblwgeom.a:
 	$(MAKE) -C ../../liblwgeom

Modified: trunk/raster/rt_pg/rtpostgis.sql.in
===================================================================
--- trunk/raster/rt_pg/rtpostgis.sql.in	2019-10-17 05:29:47 UTC (rev 17924)
+++ trunk/raster/rt_pg/rtpostgis.sql.in	2019-10-17 10:29:15 UTC (rev 17925)
@@ -2410,7 +2410,8 @@
 
 		RETURN @extschema at ._ST_asraster(g, scale_x, scale_y, NULL, NULL, $3, $4, $5, NULL, NULL, ul_x, ul_y, skew_x, skew_y, $6);
 	END;
-	$$ LANGUAGE 'plpgsql' IMMUTABLE _PARALLEL;
+	$$ LANGUAGE 'plpgsql' IMMUTABLE _PARALLEL
+	SET search_path = @extschema@;
 
 CREATE OR REPLACE FUNCTION st_asraster(
 	geom geometry,
@@ -7731,7 +7732,8 @@
 		RETURN  @extschema at ._add_raster_constraint(cn, sql);
 	END;
 	$$ LANGUAGE 'plpgsql' VOLATILE STRICT
-	COST 100;
+	COST 100
+	SET search_path = @extschema@;
 
 CREATE OR REPLACE FUNCTION _drop_raster_constraint_coverage_tile(rastschema name, rasttable name, rastcolumn name)
 	RETURNS boolean AS
@@ -9093,7 +9095,8 @@
 
   RETURN;
 END;
-$$ LANGUAGE 'plpgsql' STABLE STRICT;
+$$ LANGUAGE 'plpgsql' STABLE STRICT
+SET search_path = @extschema@;
 
 ------------------------------------------------------------------------------
 -- ST_CreateOverview