[postgis-users] query a certain row from a table.

Martin Davis mtnclimb at gmail.com
Sat Mar 21 17:24:26 PDT 2020

Is it possible you are simply exceeding the allowable size for a
shapefile?  The SHP file is limited to a size of 2 GB.

On Fri, Mar 20, 2020 at 9:35 PM john polo <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?
> --
> Enlightenment is ego's ultimate disappointment.
> -Chogyam Trungpa
> _______________________________________________
> 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/20200321/88c53160/attachment.html>

More information about the postgis-users mailing list