How are you determining that the geometry field is null are you actually doing a
SELECT * FROM blah where the_geom is NULL If you are looking at it from say PgAdminIII, it may look blank. That's just a limitation in PgAdminIII - not in PostGIS. If you do a SELECT ST_NumGeometries(the_geom) from blah on those blank ones - if it returns a number you should be fine. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of davidj2k Sent: Wednesday, March 12, 2008 12:50 PM To: [email protected] Subject: [postgis-users] Does geometry field type have a size limit? 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--tp1600 6438p16006438.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
