[postgis-tickets] [SCM] PostGIS branch stable-3.3 updated. 3.3.1-12-ga0e206a9d
git at osgeo.org
git at osgeo.org
Sun Oct 2 13:56:20 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.3 has been updated
via a0e206a9d956d488a30126b019cc91a156977e7d (commit)
via 5312e0b21e9301fcd88f67440fa1e151c58ad1a9 (commit)
via 93b98069713d46282cd23c3bedec6fc82242a513 (commit)
via 98070faad220e12fcaed9a583a70a37c510b7c6b (commit)
from c0e66c7af3791452c2da09506204949945fbc063 (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 a0e206a9d956d488a30126b019cc91a156977e7d
Merge: 5312e0b21 93b980697
Author: Regina Obe <lr at pcorp.us>
Date: Sun Oct 2 16:51:52 2022 -0400
Merge remote-tracking branch 'tpetazzoni/no-force-static-link' into stable-3.3
References #5255 for PostGIS 3.3.2 , GH702
Remove forced static linking on raster2pgsql (Thomas Petazzoni)
diff --cc NEWS
index 1c7dc317c,e77dfc2c9..a03745906
--- a/NEWS
+++ b/NEWS
@@@ -1,109 -1,5 +1,110 @@@
+PostGIS 3.3.2
+xxxx/xx/xx
+
+* Bug Fix *
+ - #5248, Marc21 documentation missing (Regina Obe)
+ - #5420, ST_DumpPoints and ST_DumpSegments crash with empty polygon (Regina Obe)
+ - Add schema qual to upgrade util (Regina Obe)
+ - #5255, GH598, Remove forced static linking on shp2pgsql, pgsql2shp (Maxim Kochetkov)
++ - #5255, GH702, Remove forced static linking on raster2pgsql (Thomas Petazzoni)
+
+
+PostGIS 3.3.1
+2022/09/09
+
+ * Bug Fix *
+ - #5227, typo in ST_LineLocatePoint error message (Sandro Santilli)
+ - #5231, PG15 no longer compiles because SQL/JSON removed PG upstream (Regina Obe)
+
+PostGIS 3.3.0
+2022/08/26
+
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, ST_ConcaveHull and several other enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+The new --enable-lto flag improves math computations. This new feature is disabled by default
+because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
+
+Use below to enable it.
+
+ ./configure --enable-lto flag
+
+ * New features *
+ - #5116, Topology export/import scripts (Sandro Santilli)
+ - ST_Letters creates geometries that look like letters (Paul Ramsey)
+ - #5037, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)
+ - postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
+ (Loïc Bartoletti)
+ - GH659, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)
+ - #5132, GH683, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)
+ - #5143, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
+ Requires SFCGAL 1.4.1+ (Loïc Bartoletti)
+ - #5162, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)
+ - #5162, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)
+ - #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)
+
+ * Breaking changes *
+ - Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
+ - Change output for WKT MULTIPOINT. All points now
+ wrapped in parens. (Even Roualt)
+ - GH674, geometry validation and fixing is disabled
+ for ST_DumpAsPolygons and ST_Polygon so it works faster
+ but might produce invalid polygons. (Aliaksandr Kalenik)
+
+ * Enhancements *
+ - #2861, Add index on topology.node(containing_face) speeding up
+ splitting and merging of faces (Sandro Santilli)
+ - #2083, Speed up ST_RemEdge topology functions adding index on
+ relation(element_id) and edge_data(abs_next*) (Sandro Santilli)
+ - #5118, Allow dropping topologies with missing topogeometry sequences
+ (Sandro Santilli)
+ - #5111, faster topology face MBR computation (Sandro Santilli)
+ - postgis_extensions_upgrade() support for upgrades from any PostGIS
+ version, including yet to be released ones (Sandro Santilli)
+ - #5040, add postgis_sfcgal_full_version (Loïc Bartoletti)
+ - GH655, GiST: balance the tree splits better in recursive calls (Darafei Praliaskouski)
+ - GH657, GiST: do not call no-op decompress function (Aliaksandr Kalenik)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
+ - ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)
+ - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
+ - GH676, faster ST_Clip (Aliaksandr Kalenik)
+ - #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
+ - #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
+ control number of rows per copy statement.
+ Default to 50 when not specified (Regina Obe)
+ - GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
+ - #5024, Update spatial_ref_sys as part of ALTER EXTENSION update postgis (Paul Ramsey)
+
+ * Bug Fix *
+ These are fixes not backported to older minors
+ - #4912, GiST: fix crash on STORAGE EXTERNAL for geography (Aliaksandr Kalenik)
+ - #5088, Memory corruption in mvt_agg_transfn (Victor Collod)
+ - #5137, resetting interrupt flags before query execution (Sergei Shoulbakov)
+ - #5148, ST_Clip is more robust to alignment of raster and clip geometry (Sergei Shoulbakov)
+ - #4932, Bug with geography ST_Intersects / ST_Distance (Paul Ramsey)
+ - #5089, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)
+
+PostGIS 3.3.0rc2
+2022/08/21
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+ - #5089, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)
+ - #5181, Reset proj error state after failed parse (Paul Ramsey)
+ - #5171, Short circuit geodesic distance when inputs equal (Paul Ramsey)
+
+
PostGIS 3.3.0rc1
-2022/xx/xx
+2022/08/08
This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
Additional features are enabled if you are running GEOS 3.9+
ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
commit 5312e0b21e9301fcd88f67440fa1e151c58ad1a9
Merge: c0e66c7af 98070faad
Author: Regina Obe <lr at pcorp.us>
Date: Sun Oct 2 16:43:36 2022 -0400
Merge remote-tracking branch 'fidomax/patch-4' into stable-3.3
Remove force static linking of postgis command line tools
References #5255 for PostGIS 3.3.2
References GH598
Contribution from Maxim Kochetkov
diff --cc NEWS
index c15c587de,ed9584b33..1c7dc317c
--- a/NEWS
+++ b/NEWS
@@@ -1,415 -1,5 +1,416 @@@
-PostGIS 3.2.0
-2021/xx/xx
+PostGIS 3.3.2
+xxxx/xx/xx
+
+* Bug Fix *
+ - #5248, Marc21 documentation missing (Regina Obe)
+ - #5420, ST_DumpPoints and ST_DumpSegments crash with empty polygon (Regina Obe)
+ - Add schema qual to upgrade util (Regina Obe)
++ - #5255, GH598, Remove forced static linking on shp2pgsql, pgsql2shp (Maxim Kochetkov)
+
+
+PostGIS 3.3.1
+2022/09/09
+
+ * Bug Fix *
+ - #5227, typo in ST_LineLocatePoint error message (Sandro Santilli)
+ - #5231, PG15 no longer compiles because SQL/JSON removed PG upstream (Regina Obe)
+
+PostGIS 3.3.0
+2022/08/26
+
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, ST_ConcaveHull and several other enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+The new --enable-lto flag improves math computations. This new feature is disabled by default
+because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
+
+Use below to enable it.
+
+ ./configure --enable-lto flag
+
+ * New features *
+ - #5116, Topology export/import scripts (Sandro Santilli)
+ - ST_Letters creates geometries that look like letters (Paul Ramsey)
+ - #5037, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)
+ - postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
+ (Loïc Bartoletti)
+ - GH659, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)
+ - #5132, GH683, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)
+ - #5143, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
+ Requires SFCGAL 1.4.1+ (Loïc Bartoletti)
+ - #5162, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)
+ - #5162, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)
+ - #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)
+
+ * Breaking changes *
+ - Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
+ - Change output for WKT MULTIPOINT. All points now
+ wrapped in parens. (Even Roualt)
+ - GH674, geometry validation and fixing is disabled
+ for ST_DumpAsPolygons and ST_Polygon so it works faster
+ but might produce invalid polygons. (Aliaksandr Kalenik)
+
+ * Enhancements *
+ - #2861, Add index on topology.node(containing_face) speeding up
+ splitting and merging of faces (Sandro Santilli)
+ - #2083, Speed up ST_RemEdge topology functions adding index on
+ relation(element_id) and edge_data(abs_next*) (Sandro Santilli)
+ - #5118, Allow dropping topologies with missing topogeometry sequences
+ (Sandro Santilli)
+ - #5111, faster topology face MBR computation (Sandro Santilli)
+ - postgis_extensions_upgrade() support for upgrades from any PostGIS
+ version, including yet to be released ones (Sandro Santilli)
+ - #5040, add postgis_sfcgal_full_version (Loïc Bartoletti)
+ - GH655, GiST: balance the tree splits better in recursive calls (Darafei Praliaskouski)
+ - GH657, GiST: do not call no-op decompress function (Aliaksandr Kalenik)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
+ - ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)
+ - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
+ - GH676, faster ST_Clip (Aliaksandr Kalenik)
+ - #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
+ - #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
+ control number of rows per copy statement.
+ Default to 50 when not specified (Regina Obe)
+ - GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
+ - #5024, Update spatial_ref_sys as part of ALTER EXTENSION update postgis (Paul Ramsey)
+
+ * Bug Fix *
+ These are fixes not backported to older minors
+ - #4912, GiST: fix crash on STORAGE EXTERNAL for geography (Aliaksandr Kalenik)
+ - #5088, Memory corruption in mvt_agg_transfn (Victor Collod)
+ - #5137, resetting interrupt flags before query execution (Sergei Shoulbakov)
+ - #5148, ST_Clip is more robust to alignment of raster and clip geometry (Sergei Shoulbakov)
+ - #4932, Bug with geography ST_Intersects / ST_Distance (Paul Ramsey)
+ - #5089, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)
+
+PostGIS 3.3.0rc2
+2022/08/21
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+ - #5089, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)
+ - #5181, Reset proj error state after failed parse (Paul Ramsey)
+ - #5171, Short circuit geodesic distance when inputs equal (Paul Ramsey)
+
+
+PostGIS 3.3.0rc1
+2022/08/08
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+Changes since PostGIS 3.3.0beta2:
+* Bug fixes *
+ - #5154, raster ST_Value is undercosted (Regina Obe)
+ - #5157, Revise minimum_bounding_circle Cunit test
+ to be tolerant of small 32-bit floating point differences
+ (Regina Obe)
+ - #5191, Functions should 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)
+ - #5025, Ensure that additional operators are not appended
+ when the function and opfamily disagree
+ about dimensionality (Paul Ramsey)
+ - #5195, #5196 Change address_standardizer
+ and postgis_tiger_geocoder CREATE EXTENSION to use CREATE
+ instead of CREATE OR REPLACE. (Regina Obe)
+ - #5202, Guard against downgrade (Sandro Santilli)
+ - #5104, postgis_extensions_upgrade() fails with pgextwlist (Regina Obe)
+
+
+PostGIS 3.3.0beta2
+2022/07/13
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+Changes since PostGIS 3.3.0beta1
+
+* New features *
+ - #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)
+
+* Enhancements *
+ - GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
+
+* Bug fixes *
+ - #5179, pgsql2shp syntax error on big-endian (Bas Couwenberg)
+
+PostGIS 3.3.0beta1
+2022/07/03
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
+
+NOTE: GEOS 3.11.0 was recently released,
+ details at https://libgeos.org/posts/2022-07-01-geos-3-11-0-released/.
+
+The new --enable-lto flag improves math computations. This new feature is disabled by default
+because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
+
+Use below to enable it.
+
+ ./configure --enable-lto flag
+
+Changes since PostGIS 3.3.0alpha1
+* Enhancements *
+ - #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
+ - #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
+ control number of rows per copy statement.
+ Default to 50 when not specified (Regina Obe)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)
+ - #5039, postgis_tiger_geocoder TIGER 2021 (Regina Obe)
+
+* New features *
+ - #5169, ST_SimplifyPolygonHull (requires GEOS 3.11)
+ (Paul Ramsey, Martin Davis)
+ - #5162, ST_TriangulatePolygon with GEOS 3.11+
+ (Paul Ramsey, Martin Davis)
+
+* Bug fixes *
+ - #5173 st_asflatgeobuf detoast crash (Paul Ramsey)
+ - #4932, Bug with geography ST_Intersects / ST_Distance (Paul Ramsey)
+ - #5114, pgsql2shp segfault with long or many truncated columns
+
+
+PostGIS 3.3.0alpha1
+2022/05/21
+
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, ST_ConcaveHull enhancements with GEOS 3.11+.
+
+NOTE: GEOS 3.11+ is not yet released, you can download from https://github.com/libgeos/geos.
+
+The new --enable-lto flag improves math computations. This new feature is disabled by default
+because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
+
+Use below to enable it.
+
+ ./configure --enable-lto flag
+
+
+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 | 2 ++
loader/Makefile.in | 2 +-
raster/loader/Makefile.in | 2 +-
3 files changed, 4 insertions(+), 2 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list