[postgis-tickets] [SCM] PostGIS branch stable-3.2 updated. 3.2.3-14-gebab0be6a
git at osgeo.org
git at osgeo.org
Sun Oct 2 23:16:52 PDT 2022
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 ebab0be6a6ae1e9d4b50f96a95f3f35d61ab0e94 (commit)
via 7c8c14b26e8b38c1dbcc0a517e8b4c1e01596b63 (commit)
via 98070faad220e12fcaed9a583a70a37c510b7c6b (commit)
from e62bf6eb7555b180319abee86245b5c94e4d2ea8 (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 ebab0be6a6ae1e9d4b50f96a95f3f35d61ab0e94
Author: Regina Obe <lr at pcorp.us>
Date: Mon Oct 3 02:15:13 2022 -0400
ReImove forced static linking on raster2pgsql (Thomas Petazzoni)
References #5255 for PostGIS 3.2.4
Referebces https://github.com/postgis/postgis/pull/702 for PostGIS 3.2.4
diff --git a/NEWS b/NEWS
index bc53e1858..6f1e95bfe 100644
--- a/NEWS
+++ b/NEWS
@@ -7,6 +7,7 @@ PostGIS 3.2.4
- #5420, ST_DumpPoints and ST_DumpSegments crash with empty polygon (Regina Obe)
- Add schema qual to upgrade util
- #5255, GH598, Remove forced static linking on shp2pgsql, pgsql2shp (Maxim Kochetkov)
+ - #5255, GH702, Remove forced static linking on raster2pgsql (Thomas Petazzoni)
PostGIS 3.2.3
diff --git a/raster/loader/Makefile.in b/raster/loader/Makefile.in
index 3df47a96f..d0a408333 100644
--- a/raster/loader/Makefile.in
+++ b/raster/loader/Makefile.in
@@ -36,7 +36,7 @@ PGSQL_BINDIR=@PGSQL_BINDIR@
RT_CORE=../rt_core
-LIBLWGEOM_LDFLAGS= -static ../../liblwgeom/liblwgeom.la
+LIBLWGEOM_LDFLAGS= ../../liblwgeom/liblwgeom.la
LIBLWGEOM_CFLAGS=-I../../liblwgeom
LIBGDAL_CFLAGS=@LIBGDAL_CFLAGS@
LIBGDAL_LDFLAGS=@LIBGDAL_LDFLAGS@
commit 7c8c14b26e8b38c1dbcc0a517e8b4c1e01596b63
Merge: e62bf6eb7 98070faad
Author: Regina Obe <lr at pcorp.us>
Date: Mon Oct 3 01:53:17 2022 -0400
Merge remote-tracking branch 'fidomax/patch-4' into stable-3.2
Remove forced static linking on shp2pgsql, pgsql2shp (Maxim Kochetkov)
References #5255 for PostGIS 3.2.4
References https://github.com/postgis/postgis/pull/598 for PostGIS 3.2.4
diff --cc NEWS
index da8f2f5fb,ed9584b33..bc53e1858
--- a/NEWS
+++ b/NEWS
@@@ -1,290 -1,5 +1,292 @@@
-PostGIS 3.2.0
-2021/xx/xx
+PostGIS 3.2.4
- 2022/09/xx
++2022/xx/xx
+
+* Bug Fixes *
+ - #5227, typo in ST_LineLocatePoint error message (Sandro Santilli)
+ - #5231, PG15 no longer compiles because SQL/JSON removed PG upstream (Regina Obe)
+ - #5420, ST_DumpPoints and ST_DumpSegments crash with empty polygon (Regina Obe)
+ - Add schema qual to upgrade util
++ - #5255, GH598, Remove forced static linking on shp2pgsql, pgsql2shp (Maxim Kochetkov)
++
+
+PostGIS 3.2.3
+2022/08/18
+
+This version requires PostgreSQL 9.6-15, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+
+ (and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.
+
+* Bug Fixes *
+ - #5191, Use integer instead of int4 (Regina Obe)
+ - #5139, PostGIS causes to_jsonb to no longer be parallel safe,
+ ST_AsGeoJSON and ST_AsGML are also parallel unsafe
+ (Regina Obe, Paul Ramsey)
+ - #5202, Guard against downgrades (Sandro Santilli)
+ - #5209, #5210, Fix upgrades with CVE-2022-2625 PostgreSQL fix
+ - #5032, Correctly read extent off multi-key GIST indexes (Paul Ramsey)
+ - #5181, Reset proj error state after failed parse (Paul Ramsey)
+ - #5171, Short circuit geodesic distance when inputs equal (Paul Ramsey)
+ - Fix potential buffer overflow in long transaction locks (Paul Ramsey)
+
+PostGIS 3.2.2
+2022/07/22
+
+This version requires PostgreSQL 9.6-15, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+
+ (and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.
+
+* Bug Fixes *
+ - #5182, Fix loading topology.sql in new database (Sandro Santilli)
+ - #4835, Occasional distance errors in polar area (Paul Ramsey)
+ - #5124, GRANT USAGE on topology schema to PUBLIC (Sandro Santilli)
+ - #5120, Fix not-null result from ST_EstimatedExtent against
+ truncated tables with spatial index (Sandro Santilli)
+ - #5115, Allow dropping topologies with pending constraints
+ (Sandro Santilli)
+ - #5105, Fix false invalidity report from ValidateTopology
+ (Sandro Santilli)
+ - #5039, postgis_tiger_geocoder: Support for TIGER 2021 (Regina Obe)
+ - #5097, Ensure spatial index is used during topology population
+ at the getClosestEdge step (Sandro Santilli)
+ - #5091, Fix --without-protobuf builds (Tobias Bussmann)
+ - #5100, Don't use pg_atoi (removed in PG15) (Laurenz Albe)
+ - #5114, Crash with long column names pgsql2shp (Paul Ramsey)
+ - #5123, Support for PG15 (JSON funcs exposed) (Regina Obe)
+ - #5125, Fix search path function (Sandro Santilli)
+ - #5150, Change signature of AddToSearchPath (Regina Obe)
+ - #5151, ST_SetPoint with empty geometries (Regina Obe)
+ - #5152, Fix infinite loop with ST_Split (Sandro Santilli)
+ - #5173, Crash creating flatgeobuf on row without geometry (Julien Rouhaud)
+ - #4541, ST_ConcaveHull returns a "geometrycollection" type instead of the expected "polygon"
+- - #5154, raster ST_Value is undercosted (Regina Obe)
+
+
+PostGIS 3.2.1
+2022/02/12
+
+* Bug Fixes *
+ - #5033, #5035, allow upgrades in presence of views using deprecated
+ functions (Sandro Santilli)
+ - #5046, Fix upgrades in absence of old library (Sandro Santilli)
+ - #5063, Fix ST_Srid(TopoGeometry) against a set (Sandro Santilli)
+ - #3056, spurious notice on ST_StartPoint(empty) (Paul Ramsey)
+ - #5041, postgis_tiger_geocoder: loader_generate_script
+ generates script with invalid syntax (Regna Obe)
+ - #5076, stop install when pgaudit is active (Paul Ramsey)
+ - #5069, search_path vulnerabilty during install/upgrade
+ (Regina Obe)
+ - #5090, #5091 configure --with-protobuf-lib / --with-protobufdir
+ , --without-protobuf broken (Tobias Bussmann)
+
+PostGIS 3.2.0 (Olivier Courtin Edition)
+2021/12/17
+
+This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher
+, and Proj 4.9+.
+Additional features are enabled if you are running GEOS 3.9+
+(and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.
+Due to some query performance degradation
+with the new fast index build that requires PG14,
+we have decided to disable the feature by default
+until we get more user testing
+as to the true impact of real-world queries.
+If you are running PG14+, you can reenable it by doing
+
+ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
+ ADD FUNCTION 11 (geometry)
+ geometry_gist_sortsupport_2d (internal);
+and then reindex your gist indexes.
+
+To revert back to the old index behavior:
+ ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
+ DROP FUNCTION 11 (geometry);
+
+and then reindex your gist indexes.
+
+ * Breaking changes *
+ - #5008, Empty geometries are not reported as being within Infinite
+ distance by ST_DWithin (Sandro Santilli)
+ - #4824, Removed `--without-wagyu` build option. Using Wagyu is now mandatory to build with MVT support.
+ - #4933, topology.GetFaceByPoint will not work with topologies having invalid edge linking.
+ - #4981, ST_StartPoint support any geometry. No longer returns null for non-linestrings.
+ - #4149, ST_AsMVTGeom now preserves more of original geometry's details at scale close to target extent.
+ If you need previous simplifying behaviour, you can ST_Simplify the geometry in advance.
+ (Darafei Praliaskouski)
+ - Proj 4.9 or higher is required
+ - #5000, Turn off Window support in ST_AsMVT aggregate
+ as no real use-case for it and it crashes with random input
+ (Paul Ramsey)
+
+ * Enhancements *
+ - #4997, FlatGeobuf format input/output (Björn Harrtell)
+ - #4575, GRANT SELECT on topology metadata tables to PUBLIC (Sandro Santilli)
+ - #2592, Do not allow CreateTopology to define topologies with SRID < 0
+ (Sandro Santilli)
+ - #3232, Prevent moving an isolated node to different face
+ (Sandro Santilli)
+ - Consider collection TopoGeometries while editing topology primitives.
+ (Sandro Santilli)
+ - #3248, Prevent removing isolated edges if used in a TopoGeometry
+ (Sandro Santilli)
+ - #3231, Prevent removing isolated nodes if used in a TopoGeometry
+ (Sandro Santilli)
+ - #3239, Prevent headling topology edges if the connecting node is
+ used in the definition of a TopoGeometry (Sandro Santilli)
+ - #4950, Speed up checking containing_face for nodes in ValidateTopology
+ (Sandro Santilli)
+ - #4945, Multi-shell face check in ValidateTopology (Sandro Santilli)
+ - #4944, Side-location conflict check in ValidateTopology (Sandro Santilli)
+ - #3042, ValidateTopology check for edge linking (Sandro Santilli)
+ - #3276, ValidateTopology check for face's mbr (Sandro Santilli)
+ - #4936, Bounding box limited ValidateTopology (Sandro Santilli)
+ - #4933, Speed up topology building in presence of big faces (Sandro Santilli)
+ - #3233, ValidateTopology check for node's containing_face (Sandro Santilli)
+ - #4830, ValidateTopology check for edges side face containment
+ (Sandro Santilli)
+ - #4827, Allow NaN coordinates in WKT input (Paul Ramsey)
+ - ST_Value() accepts resample parameter to add bilinear option (Paul Ramsey)
+ - #3778, #4401, ST_Boundary now works for TIN and does not linearize curves (Aliaksandr Kalenik)
+ - #4881, #4884, Store sign of edge_id for lineal TopoGeometry in relation table
+ to retain direction (Sandro Santilli)
+ - #4628, Add an option to disable ANALYZE when loading shapefiles (Stefan Corneliu Petrea)
+ - #4924, Faster ST_RemoveRepeatedPoints on large multipoints, O(NlogN) instead of O(N^2)
+ (Aliaksandr Kalenik, Darafei Praliaskouski)
+ - #4925, fix ST_DumpPoints to not overlook points (Aliaksandr Kalenik)
+ - ST_SRID(topogeometry) override, to speedup lookups (Sandro Santilli)
+ - #2175, Avoid creating additional nodes when adding same closed
+ line to topology (Sandro Santilli)
+ - #4974, Upgrade path for address_standardizer_data_us
+ (Jan Katins of Aiven, Regina Obe)
+ - #4975, PostGIS upgrade change to not use temp tables (Jan Katins of Aiven)
+ - #4981, ST_StartPoint support any geometry (Aliaksandr Kalenik)
+ - #4799, Include srs in GeoJSON where it exists in spatial_ref_sys.
+ - #4986, GIST indexes on Postgres 14 are now created faster using Hilbert-sorting method.
+ (Han Wang, Aliaksandr Kalenik, Darafei Praliaskouski, Giuseppe Broccolo)
+ - #4949, Use proj_normalize_for_visualization to hand "axis swap" decisions (Paul Ramsey)
+ - GH647, ST_PixelAsCentroids, ST_PixelAsCentroid reimplemented on top of a C function (Sergei Shoulbakov)
+ - GH648, ST_AsMVTGeom now uses faster clipping (Aliaksandr Kalenik)
+ - #5018, pgsql2shp basic support for WITH CTE clause (Regina Obe)
+ - #5019, address_standardizer: Add support for pcre2 (Paul Ramsey)
+
+ * New features*
+ - #4923, topology.ValidateTopologyRelation (Sandro Santilli)
+ - #4933, topology.GetFaceContainingPoint (Sandro Santilli)
+ - #2175, ST_Scroll (Sandro Santilli)
+ - #4841, FindTopology to quickly get a topology record (Sandro Santilli)
+ - #4869, FindLayer to quickly get a layer record (Sandro Santilli)
+ - #4851, TopoGeom_addTopoGeom function (Sandro Santilli)
+ - ST_MakeValid(geometry, options) allows alternative validity building
+ algorithms with GEOS 3.10 (Paul Ramsey)
+ - ST_InterpolateRaster() fills in raster cells between sample points
+ using one of a number of algorithms (inverse weighted distance, average, etc)
+ using algorithms from GDAL
+ (Paul Ramsey)
+ - ST_Contour() generates contour lines from raster values
+ using algorithms from GDAL (Paul Ramsey)
+ - ST_SetZ()/ST_SetM() fills in z/m coordinates of a geometry using data read
+ from a raster (Paul Ramsey)
+ - New postgis.gdal_vsi_options GUC allows out-db rasters on VSI network
+ services to be accessed with authentication keys, etc. (Paul Ramsey)
+ - ST_DumpSegments returns a set of segments of input geometry (Aliaksandr Kalenik)
+ - #4859, ST_Point, ST_PointZ, ST_PointM, ST_PointZM, constructors
+ with SRID parameter (Paul Ramsey)
+ - #4808, ST_ClusterKMeans now supports max_radius argument. Use it when you're not sure what is
+ the number of clusters but you know what the size of clusters should be. (Darafei Praliaskouski)
+
+PostGIS 3.2.0beta3
+2021/12/04
+This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+
+(and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.
+Due to some query performance degradation
+with the new fast index build that requires PG14,
+we have decided to disable the feature by default
+until we get more user testing
+as to the true impact of real-world queries.
+If you are running PG14+, you can reenable it by doing
+
+ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
+ ADD FUNCTION 11 (geometry)
+ geometry_gist_sortsupport_2d (internal);
+
+To revert the change:
+ ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
+ DROP FUNCTION 11 (geometry);
+
+and then reindex your gist indexes.
+
+Changes since PostGIS 3.2.0beta2 release:
+ * Breaking changes / fixes *
+ - #5028, ST_AsFlatGeobuf crashes on mixed geometry input
+ (Björn Harrtell)
+ - #5029, ST_AsFlatGeobuf indexed output corruption
+ (Björn Harrtell)
+ - #5014, Crash on ST_TableFromFlatGeobuf (Björn Harrtell)
+ - Rename ST_TableFromFlatGeobuf to ST_FromFlatGeobufToTable
+ (Björn Harrtell)
+ - PG14 fast index building disabled by default. (Paul Ramsey)
+
+PostGIS 3.2.0beta2
+2021/11/26
+This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+
+(and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.
+
+Changes since PostGIS 3.2.0beta1 release:
+ * Breaking changes / fixes *
+ - #5016, loader (shp2pgsql): Respect LDFLAGS (Greg Troxel)
+ - #5005, ST_AsFlatGeoBuf crashes on tables when geometry
+ column is not the first column (Björn Harrtell)
+ - #5017, topology.ValidateTopology error relation "shell_check"
+ already exists (Sandro Santilli)
+
+ * Enhancements *
+ - #5018, pgsql2shp basic support for WITH CTE clause (Regina Obe)
+ - #5019, address_standardizer: Add support for pcre2 (Paul Ramsey)
+ - GH647, ST_AsMVTGeom now uses faster clipping (Aliaksandr Kalenik)
+ - GH648, ST_PixelAsCentroids, ST_PixelAsCentroid
+ reimplemented in C (Sergei Shoulbakov)
+
+
+PostGIS 3.2.0beta1
+2021/10/23
+
+This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+
+(and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.
+
+Changes since PostGIS 3.2.0alpa1 release:
+
+ * Bug Fixes and Breaking Changes *
+ - #5012, Clean regress against released GEOS 3.10.0
+ (Regina Obe, Paul Ramsey)
+ - #5000, Turn off Window support in ST_AsMVT aggregate
+ as no real use-case for it and it crashes with random input
+ (Paul Ramsey)
+ - #4994, shp2pgsql is sometimes missing the INSERT statements
+ (Sandro Santilli)
+ - #4990, getfacecontainingpoint fails on i386 (Sandro Santilli)
+ - #5008, Have ST_DWithin with EMPTY operand always return false
+ (Sandro Santilli)
+ - #5002, liblwgeom should build with warning flags by default
+ (Sandro Santilli)
+
+ * Enhancements *
+ - #4997, FlatGeobuf format input/output (Björn Harrtell)
+
+
+
+PostGIS 3.2.0alpha1
+2021/09/10
+
+This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+, Proj 6.1+, and PostgreSQL 14+.
* Breaking changes *
- #4824, Removed `--without-wagyu` build option. Using Wagyu is now mandatory to build with MVT support.
-----------------------------------------------------------------------
Summary of changes:
NEWS | 5 ++++-
loader/Makefile.in | 2 +-
raster/loader/Makefile.in | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list