2026/04/14
6055, Remove rare extension priv escalation case. Reported by Sven Klemm (Tiger Data), Allistair Ishmael Hakim (allistair.sh) and Daniel Bakker
GH-850, Use quote_identifier to build tables in pgis_tablefromflatgeobuf (Ariel Mashraki)
6058, Use Pg composite_to_json() function in 19+ (Paul Ramsey)
6060, fully quality calls to helper functions (Paul Ramsey)
6026, KNN failure in rare IEEE double rounding case (Paul Ramsey)
6061, WKT parser produces incorrect error locations (Paul Ramsey)
6069, Build warnings / CI failures on K&R style, fallthroughs (Paul Ramsey)
2026/02/09
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
6023, Fix robustness issue in ptarray_contains_point (Sandro Santilli)
6027, Fix RemoveUnusedPrimitives without topology in search_path (Sandro Santilli)
6019, make clean does not remove cunit generated files (Bas Couwenberg)
6020, schema qualify call in ST_MPointFromText (Paul Ramsey)
6028, crash indexing malformed empty polygon (Paul Ramsey)
GH-841, small memory leak in address_standardizer (Maxim Korotkov)
5853, Issue with topology and tiger geocoder upgrade scripts (Regina Obe, Spencer Bryson)
6032, Fix postgis_tiger_geocoder upgrade for PostgreSQL < 16 (Regina Obe)
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)