[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