[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-745-gbef103b65

[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  bef103b65ccb5f5ed6f4a8bb346a6e4c95c72d0e (commit)
      from  04b747974e2d0c35a568281edf6e3f61bf329cbf (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 bef103b65ccb5f5ed6f4a8bb346a6e4c95c72d0e
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Thu Apr 27 08:48:54 2023 -0700

    Preserve input SRID in SQL wrapper to synthetic buffer, closes #5378

diff --git a/postgis/geography.sql.in b/postgis/geography.sql.in
index f7e130074..948d7d4e5 100644
--- a/postgis/geography.sql.in
+++ b/postgis/geography.sql.in
@@ -641,55 +641,6 @@ CREATE OR REPLACE FUNCTION _ST_BestSRID(geography)
 	LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE
 	_COST_LOW;
 
--- Availability: 1.5.0
-CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8)
-	RETURNS geography
-	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Buffer(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1)), $2), 4326))'
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 2.3.x
-CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8, integer)
-	RETURNS geography
-	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Buffer(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1)), $2, $3), 4326))'
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 2.3.x
-CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8, text)
-	RETURNS geography
-	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Buffer(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1)), $2, $3), 4326))'
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
-CREATE OR REPLACE FUNCTION ST_Buffer(text, float8)
-	RETURNS geometry AS
-	$$ SELECT @extschema at .ST_Buffer($1::@extschema at .geometry, $2);  $$
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 2.3.x
-CREATE OR REPLACE FUNCTION ST_Buffer(text, float8, integer)
-	RETURNS geometry AS
-	$$ SELECT @extschema at .ST_Buffer($1::@extschema at .geometry, $2, $3);  $$
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 2.3.x
-CREATE OR REPLACE FUNCTION ST_Buffer(text, float8, text)
-	RETURNS geometry AS
-	$$ SELECT @extschema at .ST_Buffer($1::@extschema at .geometry, $2, $3);  $$
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 1.5.0
-CREATE OR REPLACE FUNCTION ST_Intersection(geography, geography)
-	RETURNS geography
-	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Intersection(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1, $2)), @extschema at .ST_Transform(@extschema at .geometry($2), @extschema at ._ST_BestSRID($1, $2))), 4326))'
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
-
--- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
-CREATE OR REPLACE FUNCTION ST_Intersection(text, text)
-	RETURNS geometry AS
-	$$ SELECT @extschema at .ST_Intersection($1::@extschema at .geometry, $2::@extschema at .geometry);  $$
-	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE
-	_COST_HIGH;
-
 -- Availability: 1.5.0
 CREATE OR REPLACE FUNCTION ST_AsBinary(geography)
 	RETURNS bytea
@@ -832,6 +783,55 @@ CREATE OR REPLACE FUNCTION ST_Intersects(geog1 geography, geog2 geography)
 	LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE
 	_COST_HIGH;
 
+-- Availability: 1.5.0
+CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8)
+	RETURNS geography
+	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Buffer(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1)), $2), @extschema at .ST_SRID($1)))'
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 2.3.x
+CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8, integer)
+	RETURNS geography
+	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Buffer(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1)), $2, $3), @extschema at .ST_SRID($1)))'
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 2.3.x
+CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8, text)
+	RETURNS geography
+	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Buffer(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1)), $2, $3), @extschema at .ST_SRID($1)))'
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
+CREATE OR REPLACE FUNCTION ST_Buffer(text, float8)
+	RETURNS geometry AS
+	$$ SELECT @extschema at .ST_Buffer($1::@extschema at .geometry, $2);  $$
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 2.3.x
+CREATE OR REPLACE FUNCTION ST_Buffer(text, float8, integer)
+	RETURNS geometry AS
+	$$ SELECT @extschema at .ST_Buffer($1::@extschema at .geometry, $2, $3);  $$
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 2.3.x
+CREATE OR REPLACE FUNCTION ST_Buffer(text, float8, text)
+	RETURNS geometry AS
+	$$ SELECT @extschema at .ST_Buffer($1::@extschema at .geometry, $2, $3);  $$
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 1.5.0
+CREATE OR REPLACE FUNCTION ST_Intersection(geography, geography)
+	RETURNS geography
+	AS 'SELECT @extschema at .geography(@extschema at .ST_Transform(@extschema at .ST_Intersection(@extschema at .ST_Transform(@extschema at .geometry($1), @extschema at ._ST_BestSRID($1, $2)), @extschema at .ST_Transform(@extschema at .geometry($2), @extschema at ._ST_BestSRID($1, $2))), @extschema at .ST_SRID($1)))'
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+
+-- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
+CREATE OR REPLACE FUNCTION ST_Intersection(text, text)
+	RETURNS geometry AS
+	$$ SELECT @extschema at .ST_Intersection($1::@extschema at .geometry, $2::@extschema at .geometry);  $$
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE
+	_COST_HIGH;
+
 -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
 CREATE OR REPLACE FUNCTION ST_Covers(text, text)
 	RETURNS boolean AS
@@ -859,3 +859,4 @@ CREATE OR REPLACE FUNCTION ST_Intersects(text, text)
 
 -----------------------------------------------------------------------------
 
+

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

Summary of changes:
 postgis/geography.sql.in | 99 ++++++++++++++++++++++++------------------------
 1 file changed, 50 insertions(+), 49 deletions(-)


hooks/post-receive
-- 
PostGIS