[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0beta3-6-g46e9f65c7
git at osgeo.org
git at osgeo.org
Fri Dec 10 21:00:59 PST 2021
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 46e9f65c7a157e8944b1d7aad9a226302c834a28 (commit)
from b89060db83cb8b17051b00cbf772a75e60b54a1a (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 46e9f65c7a157e8944b1d7aad9a226302c834a28
Author: Regina Obe <lr at pcorp.us>
Date: Sat Dec 11 00:00:52 2021 -0500
Prepping for 3.2.0rc1
diff --git a/NEWS b/NEWS
index 9ee0e3422..d8813fb01 100644
--- a/NEWS
+++ b/NEWS
@@ -1,6 +1,7 @@
-PostGIS 3.2.0beta3
-2021/12/04
-This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
+PostGIS 3.2.0rc1
+2021/12/XX
+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+.
@@ -14,51 +15,14 @@ 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 the change:
+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.
-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 (shp2pgsq): 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.0
-2021/xx/xx
-
* Breaking changes *
- #5008, Empty geometries are not reported as being within Infinite
distance by ST_DWithin (Sandro Santilli)
@@ -69,6 +33,9 @@ PostGIS 3.2.0
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)
@@ -118,6 +85,8 @@ PostGIS 3.2.0
- #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)
@@ -144,6 +113,65 @@ PostGIS 3.2.0
- #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
diff --git a/README.postgis b/README.postgis
index c31624ee7..64a9edd63 100644
--- a/README.postgis
+++ b/README.postgis
@@ -1,8 +1,8 @@
PostGIS - Geographic Information Systems Extensions to PostgreSQL
=================================================================
-:Version: 3.2.0beta3
-:Date: 2021-12-04
+:Version: 3.2.0rc1
+:Date: 2021-12-11
:Website: https://postgis.net
This distribution contains a module which implements GIS simple features, ties
diff --git a/Version.config b/Version.config
index 843963a1e..924c89076 100644
--- a/Version.config
+++ b/Version.config
@@ -5,7 +5,7 @@
POSTGIS_MAJOR_VERSION=3
POSTGIS_MINOR_VERSION=2
-POSTGIS_MICRO_VERSION=0dev
+POSTGIS_MICRO_VERSION=0rc1
# Liblwgeom interface versioning, reset to 0:0:0 (cur:age:rev)
# when changing POSTGIS_MINOR_VERSION
diff --git a/doc/reference_editor.xml b/doc/reference_editor.xml
index 9a4710cac..bbf5cd099 100644
--- a/doc/reference_editor.xml
+++ b/doc/reference_editor.xml
@@ -1553,6 +1553,7 @@ UPDATE sometable
<para>If the tolerance parameter is provided, vertices within the tolerance
of one another will be considered the "same" for the purposes of removal.</para>
+ <para>Enhanced: 3.2.0</para>
<para>Availability: 2.2.0</para>
<para>&P_support;</para>
<para>&Z_support;</para>
diff --git a/doc/release_notes.xml b/doc/release_notes.xml
index ee66b7aa0..5e5673af5 100644
--- a/doc/release_notes.xml
+++ b/doc/release_notes.xml
@@ -2,7 +2,123 @@
<appendix id="release_notes">
<title>Appendix</title>
<subtitle>Release Notes</subtitle>
+ <sect1>
+ <title>PostGIS 3.2.0rc1</title>
+ <para>2021/12/10</para>
+ <para>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+.</para>
+ <para>Due to some query performance degradation
+ with the new PG14 fast index build ,
+ 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:</para>
+ <programlisting>ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
+ ADD FUNCTION 11 (geometry)
+ geometry_gist_sortsupport_2d (internal);
+ </programlisting>
+ <para>To revert the change:</para>
+ <programlisting>ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
+ DROP FUNCTION 11 (geometry);</programlisting>
+ <para>and then reindex your gist indexes</para>
+ <simplesect>
+ <title>Breaking changes</title>
+ <para>5008, Empty geometries are not reported as being within Infinite
+ distance by ST_DWithin (Sandro Santilli)</para>
+ <para>4824, Removed <code>--without-wagyu</code> build option. Using Wagyu is now mandatory to build with MVT support.</para>
+ <para>4933, topology.GetFaceByPoint will not work with topologies having invalid edge linking.</para>
+ <para>4981, ST_StartPoint support any geometry. No longer returns null for non-linestrings.</para>
+ <para>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)</para>
+ <para>- Proj 4.9 or higher is required</para>
+ <para>5000, Turn off Window support in ST_AsMVT aggregate
+ as no real use-case for it and it crashes with random input
+ (Paul Ramsey)</para>
+ </simplesect>
+ <simplesect>
+ <title>Enhancements</title>
+ <para>4997, FlatGeobuf format input/output (Björn Harrtell)</para>
+ <para>4575, GRANT SELECT on topology metadata tables to PUBLIC (Sandro Santilli)</para>
+ <para>2592, Do not allow CreateTopology to define topologies with SRID < 0
+ (Sandro Santilli)</para>
+ <para>3232, Prevent moving an isolated node to different face
+ (Sandro Santilli)</para>
+ <para>- Consider collection TopoGeometries while editing topology primitives.
+ (Sandro Santilli)</para>
+ <para>3248, Prevent removing isolated edges if used in a TopoGeometry
+ (Sandro Santilli)</para>
+ <para>3231, Prevent removing isolated nodes if used in a TopoGeometry
+ (Sandro Santilli)</para>
+ <para>3239, Prevent headling topology edges if the connecting node is
+ used in the definition of a TopoGeometry (Sandro Santilli)</para>
+ <para>4950, Speed up checking containing_face for nodes in ValidateTopology
+ (Sandro Santilli)</para>
+ <para>4945, Multi-shell face check in ValidateTopology (Sandro Santilli)</para>
+ <para>4944, Side-location conflict check in ValidateTopology (Sandro Santilli)</para>
+ <para>3042, ValidateTopology check for edge linking (Sandro Santilli)</para>
+ <para>3276, ValidateTopology check for face's mbr (Sandro Santilli)</para>
+ <para>4936, Bounding box limited ValidateTopology (Sandro Santilli)</para>
+ <para>4933, Speed up topology building in presence of big faces (Sandro Santilli)</para>
+ <para>3233, ValidateTopology check for node's containing_face (Sandro Santilli)</para>
+ <para>4830, ValidateTopology check for edges side face containment
+ (Sandro Santilli)</para>
+ <para>4827, Allow NaN coordinates in WKT input (Paul Ramsey)</para>
+ <para>- ST_Value() accepts resample parameter to add bilinear option (Paul Ramsey)</para>
+ <para>3778, #4401, ST_Boundary now works for TIN and does not linearize curves (Aliaksandr Kalenik)</para>
+ <para>4881, #4884, Store sign of edge_id for lineal TopoGeometry in relation table
+ to retain direction (Sandro Santilli)</para>
+ <para>4628, Add an option to disable ANALYZE when loading shapefiles (Stefan Corneliu Petrea)</para>
+ <para>4924, Faster ST_RemoveRepeatedPoints on large multipoints, O(NlogN) instead of O(N^2)
+ (Aliaksandr Kalenik, Darafei Praliaskouski)</para>
+ <para>4925, fix ST_DumpPoints to not overlook points (Aliaksandr Kalenik)</para>
+ <para>- ST_SRID(topogeometry) override, to speedup lookups (Sandro Santilli)</para>
+ <para>2175, Avoid creating additional nodes when adding same closed
+ line to topology (Sandro Santilli)</para>
+ <para>4974, Upgrade path for address_standardizer_data_us
+ (Jan Katins of Aiven, Regina Obe)</para>
+ <para>4975, PostGIS upgrade change to not use temp tables (Jan Katins of Aiven)</para>
+ <para>4981, ST_StartPoint support any geometry (Aliaksandr Kalenik)</para>
+ <para>4799, Include srs in GeoJSON where it exists in spatial_ref_sys.</para>
+ <para>4986, GIST indexes on Postgres 14 are now created faster using Hilbert-sorting method.
+ (Han Wang, Aliaksandr Kalenik, Darafei Praliaskouski, Giuseppe Broccolo)</para>
+ <para>4949, Use proj_normalize_for_visualization to hand "axis swap" decisions (Paul Ramsey)</para>
+ <para>- GH647, ST_PixelAsCentroids, ST_PixelAsCentroid reimplemented on top of a C function (Sergei Shoulbakov)</para>
+ <para>- GH648, ST_AsMVTGeom now uses faster clipping (Aliaksandr Kalenik)</para>
+ <para>5018, pgsql2shp basic support for WITH CTE clause (Regina Obe)</para>
+ <para>5019, address_standardizer: Add support for pcre2 (Paul Ramsey)</para>
+ </simplesect>
+
+ <simplesect>
+ <title>New features</title>
+ <para>4923, topology.ValidateTopologyRelation (Sandro Santilli)</para>
+ <para>4933, topology.GetFaceContainingPoint (Sandro Santilli)</para>
+ <para>2175, ST_Scroll (Sandro Santilli)</para>
+ <para>4841, FindTopology to quickly get a topology record (Sandro Santilli)</para>
+ <para>4869, FindLayer to quickly get a layer record (Sandro Santilli)</para>
+ <para>4851, TopoGeom_addTopoGeom function (Sandro Santilli)</para>
+ <para>ST_MakeValid(geometry, options) allows alternative validity building
+ algorithms with GEOS 3.10 (Paul Ramsey)</para>
+ <para>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)</para>
+ <para>ST_Contour() generates contour lines from raster values
+ using algorithms from GDAL (Paul Ramsey)</para>
+ <para>ST_SetZ()/ST_SetM() fills in z/m coordinates of a geometry using data read
+ from a raster (Paul Ramsey)</para>
+ <para>New postgis.gdal_vsi_options GUC allows out-db rasters on VSI network
+ services to be accessed with authentication keys, etc. (Paul Ramsey)</para>
+ <para>ST_DumpSegments returns a set of segments of input geometry (Aliaksandr Kalenik)</para>
+ <para>4859, ST_Point, ST_PointZ, ST_PointM, ST_PointZM, constructors
+ with SRID parameter (Paul Ramsey)</para>
+ <para>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)</para>
+ </simplesect>
+ </sect1>
<sect1>
<title>PostGIS 3.2.0beta3</title>
<para>2021/12/04</para>
diff --git a/extensions/upgradeable_versions.mk b/extensions/upgradeable_versions.mk
index 3fc87904e..54e99c188 100644
--- a/extensions/upgradeable_versions.mk
+++ b/extensions/upgradeable_versions.mk
@@ -70,4 +70,5 @@ UPGRADEABLE_VERSIONS = \
3.2.0alpha1 \
3.2.0beta1 \
3.2.0beta2 \
- 3.2.0beta3
+ 3.2.0beta3 \
+ 3.2.0dev
-----------------------------------------------------------------------
Summary of changes:
NEWS | 112 +++++++++++++++++++++--------------
README.postgis | 4 +-
Version.config | 2 +-
doc/reference_editor.xml | 1 +
doc/release_notes.xml | 116 +++++++++++++++++++++++++++++++++++++
extensions/upgradeable_versions.mk | 3 +-
6 files changed, 192 insertions(+), 46 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list