Appendix A. Appendix
Appendix A. Appendix
Release Notes
A.1. PostGIS 3.6.1
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
Fixes
#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)
A.2. PostGIS 3.6.0
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)
Breaking Changes
#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)
Removed / Deprecate signatures
#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)
New Features
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)