[postgis-users] query a certain row from a table. (Willem Hoffmans)

Gary Turner g at elizr.com
Mon Mar 23 14:57:30 PDT 2020


Presumably if that is the case, you should be able to check that by 
having more, or less information in the metadata?

More data fields would presumably decrease the error record.

On 23/03/20 22:12, Willem wrote:
>
> I'm pretty sure it's the limitations of the Shapefile (or, more 
> precisely, the underlying .dbf format) that gives the error.
> Those .dbf files can only contain 2GB of data, see also:
>
> https://en.wikipedia.org/wiki/Shapefile
>
> So ask yourself the question: why export to shapefile? Try Geopackage, 
> for instance, it's better, without those limitations.
>
> On Mar 20, 2020, at 11:36 PM, john polo <jpolo at mail.usf.edu 
> <mailto:jpolo at mail.usf.edu>> wrote:
> 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?
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200324/eb3a9251/attachment.html>


More information about the postgis-users mailing list