<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Thanks, Willem. I'll try that instead. <br>
</p>
<p>best regards,</p>
<p>John<br>
</p>
<div class="moz-cite-prefix">On 3/23/2020 2:12 AM, Willem wrote:<br>
</div>
<blockquote type="cite"
cite="mid:43cc4dcf-b918-3bb1-17ad-5798c2baf8a5@ruimtemaatwerk.nl">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<br>
I'm pretty sure it's the limitations of the Shapefile (or, more
precisely, the underlying .dbf format) that gives the error.<br>
Those .dbf files can only contain 2GB of data, see also:<br>
<br>
<a href="https://en.wikipedia.org/wiki/Shapefile"
moz-do-not-send="true"><font face="carlito">https://en.wikipedia.org/wiki/Shapefile</font></a>
<div dir="auto"><br>
So ask yourself the question: why export to shapefile? Try
Geopackage, for instance, it's better, without those
limitations. <br>
<br>
</div>
On Mar 20, 2020, at 11:36 PM, john polo <<a
href="mailto:jpolo@mail.usf.edu" target="_blank"
moz-do-not-send="true">jpolo@mail.usf.edu</a>> wrote:
<pre>Hi,
I'm trying to export a table of points to a shapefile. The table has
over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile
Import/Export Manager on Windows 10. When I try to run the export, I
keep getting this error:
Error: record 3329432 could not be created
I'm not sure how to handle this. My first impulse is find the offending
row, but I don't know the SQL for such a query. Is there something I
need to write in a WHERE clause or a different clause to get a specific row?</pre>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Enlightenment is ego's ultimate disappointment.
-Chogyam Trungpa</pre>
</body>
</html>