[postgis-users] Does geometry field type have a size limit?

David Jordan davidj2k at yahoo.com
Wed Mar 12 10:53:18 PDT 2008



Paul Ramsey <pramsey at cleverelephant.ca> wrote:   There is no limit to the geometry field size (well, no practical limit
http://www.postgresql.org/about/, 1Gb) .

Send me your shape file to confirm if your problem is repeatable.

P.

On 3/12/08, davidj2k wrote:
>
> I am trying to convert several of my .shp files to the PostGIS database and
> when it inserts some of the larger polygons it fails to insert the geometry
> field value.
> I tried it using the shp2pgsql and I tried it using my own code in C# and I
> have even tried executing the SQL in the pgAdmin III Query function and all
> three have the exact same results the record gets inserted but the geometry
> field is null and it only happens on those records that have a lot of points
> that make up the polygon, I created several test to try and determine how
> many points were too much for it and I hit upon 1365 seemed to be the amount
> that was too many.
> Does anybody know if there is a limitation to the geometry field and if
> there is how can I increase it?
>
> Thank You
>
> --
> View this message in context: http://www.nabble.com/Does-geometry-field-type-have-a-size-limit--tp16006438p16006438.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080312/00993115/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Cntry05t.zip
Type: application/x-zip-compressed
Size: 2796757 bytes
Desc: 2090181560-Cntry05t.zip
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080312/00993115/attachment.bin>


More information about the postgis-users mailing list