[SCM] PostGIS branch master updated. 3.5.0-452-g1690dc211
git at osgeo.org
git at osgeo.org
Fri Jul 11 14:28:03 PDT 2025
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 1690dc211ad7f287cbb6a8d679040a86e9043aad (commit)
from 60b0e880d24ffcdf2d17ab22bc8109549f69fd16 (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 1690dc211ad7f287cbb6a8d679040a86e9043aad
Author: Paul Ramsey <paul.ramsey at snowflake.com>
Date: Fri Jul 11 14:27:46 2025 -0700
ST_PointFromText cannot create geometries with M (References #5902)
diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 38d009eac..50c9ba732 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -5594,7 +5594,7 @@ CREATE OR REPLACE FUNCTION ST_WKTToSQL(text)
CREATE OR REPLACE FUNCTION ST_PointFromText(text)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''POINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_Point''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5606,7 +5606,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromText(text)
CREATE OR REPLACE FUNCTION ST_PointFromText(text, integer)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''POINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_Point''
THEN @extschema at .ST_GeomFromText($1, $2)
ELSE NULL END
'
@@ -5617,7 +5617,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromText(text, integer)
CREATE OR REPLACE FUNCTION ST_LineFromText(text)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''LINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_LineString''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5628,7 +5628,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromText(text)
CREATE OR REPLACE FUNCTION ST_LineFromText(text, integer)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''LINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_LineString''
THEN @extschema at .ST_GeomFromText($1,$2)
ELSE NULL END
'
@@ -5639,7 +5639,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromText(text, integer)
CREATE OR REPLACE FUNCTION ST_PolyFromText(text)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''POLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_Polygon''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5650,7 +5650,7 @@ CREATE OR REPLACE FUNCTION ST_PolyFromText(text)
CREATE OR REPLACE FUNCTION ST_PolyFromText(text, integer)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''POLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_Polygon''
THEN @extschema at .ST_GeomFromText($1, $2)
ELSE NULL END
'
@@ -5676,7 +5676,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromText(text, integer)
RETURNS geometry
AS '
SELECT CASE
- WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''MULTILINESTRING''
+ WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_MultiLineString''
THEN @extschema at .ST_GeomFromText($1,$2)
ELSE NULL END
'
@@ -5687,7 +5687,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromText(text, integer)
CREATE OR REPLACE FUNCTION ST_MLineFromText(text)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''MULTILINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_MultiLineString''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5712,7 +5712,7 @@ CREATE OR REPLACE FUNCTION ST_MultiLineStringFromText(text, integer)
CREATE OR REPLACE FUNCTION ST_MPointFromText(text, integer)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''MULTIPOINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_MultiPoint''
THEN ST_GeomFromText($1, $2)
ELSE NULL END
'
@@ -5723,7 +5723,7 @@ CREATE OR REPLACE FUNCTION ST_MPointFromText(text, integer)
CREATE OR REPLACE FUNCTION ST_MPointFromText(text)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''MULTIPOINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_MultiPoint''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5741,7 +5741,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPointFromText(text)
CREATE OR REPLACE FUNCTION ST_MPolyFromText(text, integer)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''MULTIPOLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_MultiPolygon''
THEN @extschema at .ST_GeomFromText($1,$2)
ELSE NULL END
'
@@ -5752,7 +5752,7 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromText(text, integer)
CREATE OR REPLACE FUNCTION ST_MPolyFromText(text)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''MULTIPOLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_MultiPolygon''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5778,7 +5778,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromText(text, integer)
RETURNS geometry
AS '
SELECT CASE
- WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1, $2)) = ''GEOMETRYCOLLECTION''
+ WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1, $2)) = ''ST_GeometryCollection''
THEN @extschema at .ST_GeomFromText($1,$2)
ELSE NULL END
'
@@ -5790,7 +5790,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromText(text)
RETURNS geometry
AS '
SELECT CASE
- WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromText($1)) = ''GEOMETRYCOLLECTION''
+ WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromText($1)) = ''ST_GeometryCollection''
THEN @extschema at .ST_GeomFromText($1)
ELSE NULL END
'
@@ -5815,7 +5815,7 @@ CREATE OR REPLACE FUNCTION ST_GeomFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''POINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_Point''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5826,7 +5826,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''POINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_Point''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5837,7 +5837,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''LINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_LineString''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5848,7 +5848,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''LINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_LineString''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5859,7 +5859,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''LINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_LineString''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5870,7 +5870,7 @@ CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''LINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_LineString''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5881,7 +5881,7 @@ CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''POLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_Polygon''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5892,7 +5892,7 @@ CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''POLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_Polygon''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5903,7 +5903,7 @@ CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1,$2)) = ''POLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1,$2)) = ''ST_Polygon''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5914,7 +5914,7 @@ CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''POLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_Polygon''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5925,7 +5925,7 @@ CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''MULTIPOINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_MultiPoint''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5936,7 +5936,7 @@ CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''MULTIPOINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_MultiPoint''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5947,7 +5947,7 @@ CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1,$2)) = ''MULTIPOINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1,$2)) = ''ST_MultiPoint''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5958,7 +5958,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''MULTIPOINT''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_MultiPoint''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5969,7 +5969,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_MultiLineFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''MULTILINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_MultiLineString''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -5980,7 +5980,7 @@ CREATE OR REPLACE FUNCTION ST_MultiLineFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''MULTILINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_MultiLineString''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -5991,7 +5991,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''MULTILINESTRING''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_MultiLineString''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -6003,7 +6003,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''MULTIPOLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_MultiPolygon''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -6014,7 +6014,7 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''MULTIPOLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_MultiPolygon''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -6024,7 +6024,7 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea)
CREATE OR REPLACE FUNCTION ST_MultiPolyFromWKB(bytea, int)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''MULTIPOLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_MultiPolygon''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -6035,7 +6035,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPolyFromWKB(bytea, int)
CREATE OR REPLACE FUNCTION ST_MultiPolyFromWKB(bytea)
RETURNS geometry
AS '
- SELECT CASE WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''MULTIPOLYGON''
+ SELECT CASE WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_MultiPolygon''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -6047,7 +6047,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromWKB(bytea, int)
RETURNS geometry
AS '
SELECT CASE
- WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1, $2)) = ''GEOMETRYCOLLECTION''
+ WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1, $2)) = ''ST_GeometryCollection''
THEN @extschema at .ST_GeomFromWKB($1, $2)
ELSE NULL END
'
@@ -6059,7 +6059,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromWKB(bytea)
RETURNS geometry
AS '
SELECT CASE
- WHEN @extschema at .geometrytype(@extschema at .ST_GeomFromWKB($1)) = ''GEOMETRYCOLLECTION''
+ WHEN @extschema at .ST_GeometryType(@extschema at .ST_GeomFromWKB($1)) = ''ST_GeometryCollection''
THEN @extschema at .ST_GeomFromWKB($1)
ELSE NULL END
'
@@ -6156,7 +6156,7 @@ BEGIN
geom := @extschema at .ST_BuildArea(mline);
- IF @extschema at .GeometryType(geom) != 'POLYGON'
+ IF @extschema at .ST_GeometryType(geom) != 'ST_Polygon'
THEN
RAISE EXCEPTION 'Input returns more then a single polygon, try using BdMPolyFromText instead';
END IF;
-----------------------------------------------------------------------
Summary of changes:
postgis/postgis.sql.in | 76 +++++++++++++++++++++++++-------------------------
1 file changed, 38 insertions(+), 38 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list