[Qgis-developer] Unclear errors in PostGIS layer

[Paolo Cavallini]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 28/06/2013 14:31, Matthias Kuhn ha scritto:
> 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.

Yes, thanks Matthis for this. QGIS is probably not loading the data, that's why is
not finding errors.
I'm investigating further.
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlHNgrgACgkQ/NedwLUzIr6p9wCeNsh0orXYSC8aQ86mqAw/pJ+J
4YMAoJkM5ovbeyAQdQt9G5ny3Izy0iPR
=gzLv
-----END PGP SIGNATURE-----