الاسم
FixCorruptTopoGeometryColumn — Fixes topogeometry corruption caused by upgrade to postgis_topology 3.6.0 and higher
المختصر
text FixCorruptTopoGeometryColumn(name layerSchema, name layerTable, name layerColumn );
الوصف
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.
The function refuses to process tables with expression or partial indexes; drop or rebuild those indexes manually around the repair.
Availability: 3.6.1
أمثلة
Fix all topology columns
SELECT topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_column)
FROM topology.layer;