[postgis-users] ERROR: mixed dimension geometries

[Pierre Racine]

ST_MakeValid does the job but it is available only with 2.0...

>-----Original Message-----
>From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>bounces at postgis.refractions.net] 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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>>bounces at postgis.refractions.net] 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
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users