2025/11/13
If you are upgrading postgis_topology and have topogeometry columns, make sure to run after the upgrade to fix topogeometry corruption: SELECT topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_column) FROM topology.layer
#5978, geometry_columns needs to still parse table constraints (Paul Ramsey)
#5987, ST_GeometryN fails for non-collections (Paul Ramsey)
#5991, CircularString distance error (Paul Ramsey)
#5994, Null pointer in ST_AsGeoJsonRow (Alexander Kukushkin)
#5998, ST_Distance error on CurvePolygon (Paul Ramsey)
#5962, Consistent clipping of MULTI/POINT (Paul Ramsey)
#5998, [tiger_geocoder] [security] CVE-2022-2625, make sure tables requires by extension are owned by extension authored: Andrey Borodin (Yandex), reported by Sergey Bobrov (Kaspersky)
#5754, ST_ForcePolygonCCW reverses lines (Paul Ramsey)
#5959, #5984, Prevent histogram target overflow when analysing massive tables (Darafei Praliaskouski)
#6012, Remove memory leak from lwcircstring_from_lwpointarray (Paul Ramsey)
#6013, [tiger_geocoder] Load Tiger 2025 data (Regina Obe)
#5983, [topology] topology.FixCorruptTopoGeometryColumn to fix corruption caused by 3.6.0 upgrade (Regina Obe, Francois Bonzon)
2025/09/01
This version requires PostgreSQL 12-18beta3, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2+ is needed.
Many thanks to our translation teams, in particular:
Teramoto Ikuhiro (Japanese Team)
Daniel Nylander (Swedish Team)
Dapeng Wang, Zuo Chenwei from HighGo (Chinese Team)
Denys Kovshun (Ukrainian Team)
#5799, make ST_TileEnvelope clips envelopes to tile plane extent (Paul Ramsey)
#5829, remove constraint checking from geometry_columns view (Paul Ramsey)
#3373, GT-255, [topology] Support for upgrading domains (Ayo Adesugba, U.S. Census Bureau)
GT-252, ST_NumGeometries/ST_GeometryN treat TIN and PolyhedralSurface as unitary geometries, use ST_NumPatches/ST_PatchN for patch access (Loïc Bartoletti)
#3110, GT-242, [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
#5359, #5897, GT-260 [tiger_geocoder] Use @extschema:extension@ for PG >= 16 to schema qualify dependent extensions, switch to use typmod for tiger tables (Regina Obe)
#3110, GT-242, [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
#5498 Drop st_approxquantile(raster, double precision), wasn't usable as it triggered is not unique error when used (Regina Obe)
GH-803, [sfcgal] ADD CG_Simplify function (Loïc Bartoletti)
GH-805, [sfcgal] Add M support for SFCGAL >= 1.5.0 (Loïc Bartoletti)
GH-801, [sfcgal] ADD CG_3DAlphaWrapping function (Jean Felder)
#5894, [topology] TotalTopologySize (Sandro Santilli)
#5890, [topology] ValidateTopologyPrecision, MakeTopologyPrecise (Sandro Santilli)
#5861, [topology] Add --drop-topology switch to pgtopo_import (Sandro Santilli)
#1247, [raster] ST_AsRasterAgg (Sandro Santilli)
#5784, GT-223 Export circ_tree_distance_tree_internal for mobilitydb use (Maxime Schoemans)
GT-228 [sfcgal] Add new functions (Scale, Translate, Rotate, Buffer 3D and Straight Skeleton Partition) from SFCGAL 2 (Loïc Bartoletti)
[raster] New GUC postgis.gdal_cpl_debug, enables GDAL debugging messages and routes them into the PostgreSQL logging system. (Paul Ramsey)
#5841, Change interrupt handling to remove use of pqsignal to support PG 18 (Paul Ramsey)
Add ST_CoverageClean to edge match and gap remove polygonal coverages (Paul Ramsey) from GEOS 3.14 (Martin Davis)
#3110, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
[raster] Add ST_ReclassExact to quickly remap values in raster (Paul Ramsey)
#5971, [tiger] Option to build --without-tiger (Regina Obe)