ST_MakeValid does the job but it is available only with 2.0...
>-----Original Message----- >From: [email protected] [mailto:postgis-users- >[email protected]] On Behalf Of Pierre Racine >Sent: 16 février 2011 16:22 >To: PostGIS Users Discussion >Subject: Re: [postgis-users] ERROR: mixed dimension geometries > >Forgot to say: > >ST_IsValid returns TRUE on both geometries... > >>-----Original Message----- >>From: [email protected] [mailto:postgis-users- >>[email protected]] On Behalf Of Pierre Racine >>Sent: 16 février 2011 16:19 >>To: PostGIS Users Discussion >>Subject: [postgis-users] ERROR: mixed dimension geometries >> >>Hi, >> >>What is the meaning of: >> >>ERROR: lwcollection_construct: mixed dimension geometries: 0/2 >>SQL state: XX000 >> >>I get this when I do ST_Intersection() on two tables. Both tables contains >>only one geometry. >>ST_Dimensions give 2 for both. >> >>How can I fix it? >> >>I tried ST_Buffer(geom, 0) without success. >> >>Thanks, >> >>Pierre >> >>_______________________________________________ >>postgis-users mailing list >>[email protected] >>http://postgis.refractions.net/mailman/listinfo/postgis-users >_______________________________________________ >postgis-users mailing list >[email protected] >http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
