How you can repair invalid topology errors within postgis?

Question

I've imported the shapefile of corine land cover project to my postgis database and the

select gid, ST_IsValidReason(geom) from gis.clc2000 where not ST_IsValid(geom);

returns in every occasion

gid    |                                st_isvalidreason                                
-------+--------------------------------------------------------------------------------
     1 | IllegalArgumentException: Points of LinearRing do not form a closed linestring
.....

I know that my polygons are closed by visually instecting some of the errors.

How can I fix the topologies errors from withing the server?

edit: I'm using postgresql/postgis2.0.1, Ubuntu12.04

Answer 1

Dump the geometry as WKT (ST_AsText), fix it manually (editing the coordinates) or in a gis like Qgis (use snapping) and update the record with the new geometry.

If you can connect the server with Qgis, you can skip the first and last steps.

One good practice is to check the topology before importing data, for that I would suggest GRASS.