On Fri, Nov 15, 2013 at 11:50:42AM +0100, Rémi Cura wrote: > Yep, maybe something like > > UPDATE ukmajrdbuffer SET the_geom = ST_MakeValid(the_geom) > WHERE ST_IsValid(the_geom) = FALSE ST_MakeValid internally checks for ST_IsValid, so no need to add the condition (which would run the test twice). --strk;