Mark,<br><br>I did not mention it, but I did include the "select postgis_full_version();" output in both cases in the initial attachment, but I did not include the "select version();" results.<br><br>Here they are now...<br>
<br>For windows:<br>postgres=# select version();<br> version <br>-------------------------------------------------------------<br> PostgreSQL 8.4.0, compiled by Visual C++ build 1400, 32-bit<br>
(1 row)<br><br><br>For Linux:<br>postgres=# select version();<br> version <br>------------------------------------------------------------------------------------------------------------<br>
PostgreSQL 8.4.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10), 32-bit<br>(1 row)<br><br><br>Thank you,<br>Nathan<br><br><br><div class="gmail_quote">On Fri, Sep 11, 2009 at 9:50 AM, Mark Cave-Ayland <span dir="ltr"><<a href="mailto:mark.cave-ayland@siriusit.co.uk">mark.cave-ayland@siriusit.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">Nathan Widmyer wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Attached are two psql sessions, one on a WinXP Pro SP3 machine, another to Ubuntu Hardy 8.04. (one pair of files have unix line endings, another has DOS line endings, for your convenience).<br>
<br>
There are 18 polygons in the data set and I want to make a union out of them. The union works in Linux but fails with an exception in Windows.<br>
<br>
I received an error on the Windows box (TopologyException: found non-noded intersection ...), then brought the data over to the linux box for analysis, and curiously the operation worked.<br>
<br>
If you visualize it, I think the last polygon (#18) shares a common line segment in space with another (possibly #15), but breaks where #18 has a vertex on the line of #15.<br>
However there are at least 2 polygons that cover the same point in space so the point shouldn't even be a problem because it's not on the outside of the resulting shape.<br>
<br>
I'm sure my analysis is lacking, but wanted to communicate all I found out.<br>
Using an alternate strategy of linework does get the union shape though.<br>
<br>
<br>
Nathan<br>
</blockquote>
<br></div></div>
Hi Nathan,<br>
<br>
Thanks for the analysis and test case. One of the key bits of information you forgot to include though was the version of PostGIS and PostgreSQL being used on each box. Can you post the output of the following on both boxes:<br>
<br>
SELECT version();<br>
SELECT postgis_full_version();<br>
<br>
<br>
ATB,<br>
<br>
Mark.<br>
<br>
-- <br>
Mark Cave-Ayland - Senior Technical Architect<br>
PostgreSQL - PostGIS<br>
Sirius Corporation plc - control through freedom<br>
<a href="http://www.siriusit.co.uk" target="_blank">http://www.siriusit.co.uk</a><br>
t: +44 870 608 0063<br>
<br>
Sirius Labs: <a href="http://www.siriusit.co.uk/labs" target="_blank">http://www.siriusit.co.uk/labs</a><br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@postgis.refractions.net" target="_blank">postgis-devel@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-devel" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a><br>
</blockquote></div><br>