PostGIS

The PostGIS Team is pleased to release PostGIS 3.7.0beta1! Best Served with PostgreSQL 19 Beta2 and GEOS 3.15.0beta2.

This version requires PostgreSQL 14 - 19beta2, GEOS 3.10 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.15+ is needed. To take advantage of all SFCGAL features SFCGAL 2.3.0+ is needed.

This release contains fixes and enhancements since 3.7.0alpha1 release.

3.7.0beta1

This release is an alpha of a major release, it includes bug fixes since PostGIS 3.6.4 and new features.

Upgrading

After installing the binaries or after running pg_upgrade:

For PostGIS 3 series do below which will upgrade all your postgis extensions.

SELECT postgis_extensions_upgrade();

For PostGIS 2 series:

ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();

Bug Fixes

  • GH-1160, Adapt topology, regression expectations, and manual examples to GEOS 3.15 overlay line merging (Paul Ramsey, Darafei Praliaskouski)
  • #6093, Fix SQL generation on ppc64el when NURBS comments are preprocessed with AltiVec vector macros (Darafei Praliaskouski)
  • #6094, [upgrade] Avoid legacy string literal warnings in downgrade checks with standard_conforming_strings off (Darafei Praliaskouski)
  • #5423, Use a DTD-free expanded DocBook input for EPUB builds so out-of-tree builds do not need dbtoepub entity path support (Darafei Praliaskouski)
  • GH-898, Fix ST_DFullyWithin indexed plans and large-coordinate ring-orientation precision regressions (Darafei Praliaskouski)
  • GH-1143, [topology] Clean up TopoRingIsCCW early returns (Darafei Praliaskouski)
  • GH-1146, Reset interrupt callbacks when PostgreSQL clears cancellation state (Darafei Praliaskouski)
  • GH-1147, [doc] Fix localized EPUB help target (Darafei Praliaskouski)
  • GH-1148, [utils] Create upgrade-check tempdir safely (Darafei Praliaskouski)
  • GH-1149, [topology] Fix corrupt column fallback variables (Darafei Praliaskouski)
  • GH-1150, Free polygon orientation inputs in ST_IsPolygonCW/CCW (Darafei Praliaskouski)
  • GH-1153, [topology] Preserve large ids from edge wrappers (Darafei Praliaskouski)
  • GH-1139, [topology] Preserve large edge ids from vertex-segment proximity helper (Darafei Praliaskouski)
  • GH-1140, [liblwgeom] Cap NURBS WKT knot multiplicity (Darafei Praliaskouski)
  • GH-1141, [liblwgeom] Reject overflowing NURBS linearization segment counts (Darafei Praliaskouski)
  • GH-1151, [topology] Preserve exact zero tolerance in TopoGeometry construction (Darafei Praliaskouski)
  • GH-1152, [topology] Enforce max edge limits from reported TopoGeo_AddLinestring edge creation (Darafei Praliaskouski)
  • GH-1154, [topology] Quote TotalTopologySize catalog regclasses safely (Darafei Praliaskouski)
  • #6092, [fuzzingengine] fuzzingengine doesn’t use hardening CPPFLAGS (Bas Couwenberg)

Enhancements

  • #1986, ST_GeomFromGML support for GML ArcString and curved polygon rings (Darafei Praliaskouski)
  • GH-1161, Render manual geometry examples as build-time SVG in HTML and PDF (Darafei Praliaskouski)
  • #4749, Use point-in-polygon predicate fast paths for point-only GeometryCollections, including ST_Disjoint (Darafei Praliaskouski)
  • #3676, Mark geometry and geography btree comparison support functions as leakproof (Darafei Praliaskouski)
  • GH-875, Allow ST_OrderingEquals joins to use hash and merge join plans (Darafei Praliaskouski)
  • #2557, #2805, Document ST_MapAlgebra callback argument signatures and return semantics (Darafei Praliaskouski)
  • #1168, [raster] Support curved geometry inputs in ST_AsRaster (Darafei Praliaskouski)

If you come across any issues, feel free to report via our ticket tracker or mailing list with details

View all tickets for 3.7.0beta1 milestone.

Read the original on postgis.net ↗