[postgis-tickets] [SCM] PostGIS branch stable-3.2 updated. 3.2.4-19-g36b162bbf

git at osgeo.org git at osgeo.org
Thu Apr 27 09:24:23 PDT 2023


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, stable-3.2 has been updated
       via  36b162bbfcecaf409978306e4b96321c67cc453e (commit)
      from  fa7823d8786cec471f12e304acdc3af33d189718 (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 36b162bbfcecaf409978306e4b96321c67cc453e
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Thu Apr 27 09:08:15 2023 -0700

    Retain SRID through ST_Buffer(geography) call, references #5378

diff --git a/NEWS b/NEWS
index 0fce606cd..7ec82f71b 100644
--- a/NEWS
+++ b/NEWS
@@ -18,6 +18,7 @@ Proj 6.1+, and PostgreSQL 14+.
   - #5288, ST_LineCrossingDirection multi-cross error (Paul Ramsey)
   - #5347, _ST_BestSRID crashes on ARM with infinite geometries (Regina Obe)
   - #5363, Make ST_ClusterDBScan interruptable (Paul Ramsey)
+  - #5378, ST_Buffer(geography) drops SRID (Paul Ramsey)
 
 
 PostGIS 3.2.4
diff --git a/postgis/geography.sql.in b/postgis/geography.sql.in
index 024e14528..c6e66d3eb 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
@@ -865,6 +816,59 @@ CREATE OR REPLACE FUNCTION ST_Intersects(geography, geography)
 
 #endif /* POSTGIS_PGSQL_VERSION < 120 */
 
+-----------------------------------------------------------------------------
+
+-- 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

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

Summary of changes:
 NEWS                     |   1 +
 postgis/geography.sql.in | 102 ++++++++++++++++++++++++-----------------------
 2 files changed, 54 insertions(+), 49 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list