« Return to Thread: Does geometry field type have a size limit?

Re: Does geometry field type have a size limit?

by davidj2k :: Rate this Message:

Reply to Author | View in Thread

That was it, the value was actually there but when I looked at it in pgAdmin III it just did not draw the text.  Thank you very much.

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

 « Return to Thread: Does geometry field type have a size limit?