PostGIS
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
  1. Home
  2. /
  3. News
  4. /
  5. PostGIS 3.7.0beta2

PostGIS 3.7.0beta2

release 3.7

The PostGIS Team is pleased to release PostGIS 3.7.0beta2! 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.0beta1 release.

3.7.0beta2

This release is a beta 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

  • OSSFuzz 544223869, compare GSERIALIZED bytea round trips by geometry semantics instead of volatile bbox bytes (Darafei Praliaskouski)
  • GT-675, Preserve TRIANGLE children while normalizing malformed TINs (Darafei Praliaskouski)
  • GT-677, Fix memory leaks in ST_GeometryN and ST_DWithin (Darafei Praliaskouski)
  • GT-671, Harden extension install and upgrade SQL against attacker-controlled object resolution in writable schemas (reported by Eric Ridge, PlanetScale; fixed by Darafei Praliaskouski)
  • OSSFuzz 6302177757560832, account for GSERIALIZED float bbox rounding in fuzzer round trips (Darafei Praliaskouski)
  • GT-669, Validate FlatGeobuf size-prefixed buffers and variable-length property values before decoding (reported by Mehmet Ince; reported by Sarath Kumar, IITM Pravartak Security Team; fixed by Darafei Praliaskouski)
  • Stop the extension upgrade script running ANALYZE inside its transaction, where it could deadlock with autovacuum (Darafei Praliaskouski)
  • [liblwgeom] Reject malformed GSERIALIZED NURBS before curve evaluation (Darafei Praliaskouski)
  • OSSFuzz 5877056525893632, reject truncated encoded polyline input (Darafei Praliaskouski)
  • GT-619, Make interrupt regression tests compare timeout latency to same-machine uninterrupted runtime, avoiding false failures under slow CI load (Darafei Praliaskouski)
  • GH-897, [topology] Harden topology helper functions and maintenance SQL against identifier, tolerance, bigint, and cleanup regressions (Darafei Praliaskouski)
  • Make the computed-columns regression test assert the query plan instead of racing two stopwatches, so it no longer fails at random under CI load (Darafei Praliaskouski)
  • #4323, GT-584, [sfcgal] Document that straight-skeleton and approximate-medial-axis functions ignore input Z and return 2D geometries (Darafei Praliaskouski)
  • GT-545, Fix FlatGeobuf geometry, property, and spatial-index byte order on big-endian platforms (Darafei Praliaskouski)
  • [raster] Fix invalid reads in raster band initialization and geotransform property access (Darafei Praliaskouski)
  • #3776, [raster] Keep distinct 32-bit integer pixel values separate in ST_DumpAsPolygons (Darafei Praliaskouski)
  • GT-504, Report extension script/library version mismatches before loading functions unavailable in an older library (Darafei Praliaskouski)
  • GT-515, Reject invalid ST_LargestEmptyCircle boundaries before GEOS can spend unbounded time on them (Darafei Praliaskouski)
  • GT-484, Use column-level SELECT privileges for metadata views (Arthur Bazin)
  • #2821, [raster] Avoid raster_columns ACL dependency in overview constraints (Darafei Praliaskouski)
  • GT-521, Reject malformed GSERIALIZED payload counts before deserializing geometry data (Darafei Praliaskouski)
  • GT-564, Avoid ST_MakePolygon failures with NULL hole array entries (Darafei Praliaskouski)
  • #6109, Out-of-bounds heap read in BOX2D_out and BOX2D_expand on 65-byte box2d under ASAN (Dennis Tighe, Google)
  • #6110, Fix regression in speed with geometry_columns (Regina Obe)
  • Revert feature #1705 (constraint geometry column detection in views) Added too much overhead to geometry_columns performance (Regina Obe)
  • Schema qualify references to pg_catalog and postgis in geometry_columns and geography_columns views (Regina Obe)

Enhancements

  • Add Woodpecker linux/arm64 build and regression coverage under QEMU to match the Jenkins Berrie64 platform (Darafei Praliaskouski)
  • #1416, ST_AsX3D outputs NURBSCURVE as X3D NurbsCurve and linearizes other curve geometries (Darafei Praliaskouski)
  • #3705, ST_AsX3D outputs valid coordinate nodes for 2D multi-geometries and GeometryCollections (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.0beta2 milestone.