PostGIS 3.6.1 Released

--0000000000008a20fc064386337a
Content-Type: text/plain; charset="UTF-8"

The PostGIS development team is pleased to publish the 3.6.1 patch release.

https://postgis.net/2025/11/PostGIS-3.6.1/

  - #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)

If you are 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;

--0000000000008a20fc064386337a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">The PostGIS development team is pleased to publish the 3.6=
.1 patch release.=C2=A0<div><br></div><div><a href=3D"https://postgis.net/2=
025/11/PostGIS-3.6.1/">https://postgis.net/2025/11/PostGIS-3.6.1/</a>=C2=A0=
<br><div><br></div><div>=C2=A0 - #5978, geometry_columns needs to still par=
se table constraints (Paul Ramsey)<br>=C2=A0 - #5987, ST_GeometryN fails fo=
r non-collections (Paul Ramsey)<br>=C2=A0 - #5991, CircularString distance =
error (Paul Ramsey)<br>=C2=A0 - #5994, Null pointer in ST_AsGeoJsonRow (Ale=
xander Kukushkin)<br>=C2=A0 - #5998, ST_Distance error on CurvePolygon (Pau=
l Ramsey)<br>=C2=A0 - #5962, Consistent clipping of MULTI/POINT (Paul Ramse=
y)<br>=C2=A0 - #5998, [tiger_geocoder] [security] CVE-2022-2625, make sure =
tables requires<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0by extension ar=
e owned by extension<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0authored: =
Andrey Borodin (Yandex), reported by Sergey Bobrov (Kaspersky)<br>=C2=A0 - =
#5754, ST_ForcePolygonCCW reverses lines (Paul Ramsey)<br>=C2=A0 - #5959, #=
5984, Prevent histogram target overflow when analysing massive<br>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0tables (Darafei Praliaskouski)<br>=C2=A0 =
- #6012, Remove memory leak from lwcircstring_from_lwpointarray (Paul Ramse=
y)<br>=C2=A0 - #6013, [tiger_geocoder] Load Tiger 2025 data (Regina Obe)<br=
>=C2=A0 - #5983, [topology] topology.FixCorruptTopoGeometryColumn<br>=C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0to fix corruption caused by 3.6.0 upgrad=
e (Regina Obe, Francois Bonzon)<br></div><div><br></div><div>If you are If =
you are upgrading postgis_topology and have topogeometry columns, make sure=
 to run</div>after the upgrade to fix topogeometry corruption:<br><br>SELEC=
T topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_co=
lumn)<br>=C2=A0 =C2=A0 FROM topology.layer;<br></div></div>

--0000000000008a20fc064386337a--