FixCorruptTopoGeometryColumn
Name
FixCorruptTopoGeometryColumn — Fixes topogeometry corruption caused by upgrade to postgis_topology 3.6.0 and higher
Synopsis
text
FixCorruptTopoGeometryColumn
(
name
layerSchema
, name
layerTable
, name
layerColumn
)
;
Description
When upgrading from PostGIS topology <3.6.0 to version >3.6.0+, the topogeometry column definition was changed. This caused corruption in topogeometries created before the upgrade. This function fixes this corruption in affected tables.
Availability: 3.6.1
Examples
Fix all topology columns
SELECT topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_column)
FROM topology.layer;