[postgis-users] How to populate a column with results of isvalid

[Intengu Technologies]

I have loaded a polygon shapefile into postgis and would like to tag
each row with the results of st_isvalid in a new field. I found this
query in the postgis manual "ALTER TABLE mytable ADD CONSTRAINT
geometry_valid_check CHECK (isvalid((the_geom));" when I run the query
it picks an invalid geometry and stops

-- 
Sent from my mobile device

Sindile Bidla