[postgis-tickets] [SCM] PostGIS branch stable-3.3 updated. 3.3.2-53-g15a1827e8
git at osgeo.org
git at osgeo.org
Thu Apr 27 09:08:20 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.3 has been updated
via 15a1827e88eb8ef8e021d73c6952b5f6123f1b7f (commit)
from 1abb3e420b59a4bdb71becda56dfcf4ec947b842 (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 15a1827e88eb8ef8e021d73c6952b5f6123f1b7f
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 80d3a40a0..46ab40575 100644
--- a/NEWS
+++ b/NEWS
@@ -26,6 +26,7 @@ YYYY/MM/DD
- #5257, #5261, #5277, #5304, #5308, #5374, Support for PG16
(Paul Ramsey, Regina Obe, Sandro , Laurenz Albe)
- #5371, ST_Union segfaults (PG 11-12) (Regina Obe)
+ - #5378, ST_Buffer(geography) drops SRID (Paul Ramsey)
PostGIS 3.3.2
diff --git a/postgis/geography.sql.in b/postgis/geography.sql.in
index c48a4117d..c0ccb9ccc 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