[Qgis-developer] Unclear errors in PostGIS layer

[Matthias Kuhn]

Hi Paolo,

The following SQL statement worked for me to clean invalid geometries 
from a table, which I was not able to work with in postgis (independent 
of QGIS)

select * from multipolygons where not st_isvalid(wkb_geometry)

After inspecting the invalid geometries, you can replace "select *" 
with "delete" to get rid of the rows in question.

Hope that helps,
Matthias


On Fre 28 Jun 2013 14:27:33 CEST, Paolo Cavallini wrote:
> ********* *BEGIN ENCRYPTED or SIGNED PART* *********
>
> Hi all.
> I'm getting errors while loading a PostGIS layer:
> ===
>  Impossibile recuperare il cursore qgisf3_0
>  Errore database: ERROR:  geometry requires more points
>
>  Interrogazione: CLOSE qgisf3_0 ha restituito 7 [ERROR:  current
>  transaction is aborted, commands ignored until end of transaction block
>  ]
>  1 degli stati del cursore perso.
>  SQL: CLOSE qgisf3_0
>  Result: 7 (ERROR:  current transaction is aborted, commands ignored until
>  end of transaction block
>  )
> ===
> When checked, however, the layer has no invalid geometries (Topology checker plugin
> and Vector>Geometry>Check geometry).
> Any hint on ho to debug this?
> All the best.
> --
> Paolo Cavallini - Faunalia
> www.faunalia.eu
> Full contact details at www.faunalia.eu/pc
> Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
>
>
> ********** *END ENCRYPTED or SIGNED PART* **********
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>