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

Paul Ramsey pramsey at cleverelephant.ca
Wed Mar 12 10:13:46 PDT 2008


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 <davidj2k at yahoo.com> 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
>



More information about the postgis-users mailing list