<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Ok, I added ORDER BY<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a
href="https://github.com/3nids/qWat/blob/3c0c6728b940dd4ab2921dee104cd054a711d60f/sql/topology.sql">https://github.com/3nids/qWat/blob/3c0c6728b940dd4ab2921dee104cd054a711d60f/sql/topology.sql</a><br>
<br>
You effectively read correctly that the loop is ended as soon as an
exception is raised, since I still didn't manage to do it properly.<br>
<br>
I filled ticket 1611,
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="http://trac.osgeo.org/postgis/ticket/1612">http://trac.osgeo.org/postgis/ticket/1612</a>
Sorry, for the lack of info in, but I don't really understand the
matter.<br>
<br>
Also, I noticed something strange. Nothing is filled into the
topogeom column. When ordered, first error is raised at id 102, but
the first 100 lines have empty topogeom. In the function, if an
error is raised nothing is committed?<br>
<br>
I wrote a small SQL with two geometries where I have the error.<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a
href="https://github.com/3nids/qWat/blob/38cde48d509d9b9a179eea1fd4db5bbd67121dcf/sql/strk.demo.sql">https://github.com/3nids/qWat/blob/38cde48d509d9b9a179eea1fd4db5bbd67121dcf/sql/strk.demo.sql</a><br>
I putted a some " !!! " in front of drop schema to prevent any harm
to some of your schemas....just in case!<br>
<br>
Greetings,<br>
<br>
Denis<br>
<br>
On 02/24/2012 02:08 PM, Sandro Santilli wrote:
<blockquote cite="mid:20120224130836.GB9498@gnash" type="cite">
<pre wrap="">On Fri, Feb 24, 2012 at 01:52:44PM +0100, Denis Rouzaud wrote:
</pre>
<blockquote type="cite">
<pre wrap="">To be sure, we understand each others, here is the few lines of SQL
I am using:
<a class="moz-txt-link-freetext" href="https://github.com/3nids/qWat/blob/7bc65b5a43ffb9ae5947ede683ff1f2274807972/sql/topology.sql">https://github.com/3nids/qWat/blob/7bc65b5a43ffb9ae5947ede683ff1f2274807972/sql/topology.sql</a>
</pre>
</blockquote>
<pre wrap="">
It seems good to me. Do I read it correctly that it exits
the loop on first error ?
May I suggest you ORDER BY id in the loop ?
Or the order would not be predictable.
</pre>
<blockquote type="cite">
<pre wrap="">I know I have errors in topology in my pipes. So, is this correct
than I can use toTopoGeom for geometries that have incorrect
topology?
</pre>
</blockquote>
<pre wrap="">
Well, they should be fine for the population of primitives,
may give problems in the mapping between original features
and topology primitives. In any case the exception you got
doesn't reveal such problem.
</pre>
<blockquote type="cite">
<pre wrap="">Here is the result of validate topology when a part of my pipes is
in the topology column:
SELECT topology.ValidateTopology('distrib_topo');
validatetopology
---------------------------
("face without edges",0,)
(1 row)
</pre>
</blockquote>
<pre wrap="">
Uhm, that's a false positive, I tought I fixed it.
Evidently I didn't. Want to file a ticket about it ?
</pre>
<blockquote type="cite">
<pre wrap="">I can dump the db, this will be a few megas, but I would like to be
sure I am not doing anything stupid, first....
</pre>
</blockquote>
<pre wrap="">
It would help me as well if you reduce it.
The important thing is that insertion of your offending geometry
keeps hitting the exception.
You could for example try dropping edges and then nodes
which do not intersect the offending geometry's bounding box.
And see if the problem still occurs.
Best to backup the whole set first.
--strk;
,------o-.
| __/ | Delivering high quality PostGIS 2.0 !
| / 2.0 | <a class="moz-txt-link-freetext" href="http://strk.keybit.net">http://strk.keybit.net</a> - <a class="moz-txt-link-freetext" href="http://vizzuality.com">http://vizzuality.com</a>
`-o------'
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>