<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">I am no Postgre expert but we have
experienced similar cases when running complex transactions with
large geometries, i.e. faulty results.<br>
When splitting the transaction into several pieces, i.e. enforcing
COMMITs (Postgre doesn't support COMMIT inside functions), the
correct results are given.</div>
<div class="moz-cite-prefix">One guess is that this may happen for
large geometries which are pushed to TOAST tables.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Check Postgre memory parameters and
trace exactly what is happening in the database.<br>
Test also with EXTERNAL STORAGE for the geometry if they are
really large.<br>
</div>
<p><br>
</p>
<blockquote type="cite"
cite="mid:CAG+h=FHKpOn3ZJDCZN1ruBL9_wW7_U272DAt_Lcim4sqUbMu3Q@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>In the GRASS module v.in.ogr we follow pretty much the
vector API tutorial. The only difference is that we first
fetch the geometry of a feature, then the fields. When input
is a PG database, sometimes the wrong field entries are
associated with the geometries, as if geometries and field
entries were mixed up. This happens when several different
v.in.ogr processes are trying to read the same features from
the same PG database at the same time. When instead using
several different ogr2ogr processes, this mixing up of
geometries and field entries does not happen. I could not find
any hints in the OGR PostGIS documentation about how to avoid
this problem.</div>
<div><br>
</div>
<div>Any hints are highly appreciated!</div>
<div><br>
</div>
<div>Markus M<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a></pre>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Hälsningar
Andreas Oxenstierna
T-Kartor Geospatial AB
Olof Mohlins väg 12 Kristianstad
mobile: +46 733 206831
mailto: <a class="moz-txt-link-abbreviated" href="mailto:ao@t-kartor.se">ao@t-kartor.se</a>
<a class="moz-txt-link-freetext" href="http://www.t-kartor.com">http://www.t-kartor.com</a></pre>
</body>
</html>