Is it that the geometry is actually null? Don't rely on pgadmin and the data view to believe the field is null. For large geometries when viewing with pgadmin, they can appear to be null because of the way strings are handled in the extensions and not show a value in the pgadmin data view.
Does "select * where wkb_geometry is NULL;" Return the records that you believe are null from the insert? I have geometries with more than 1400 points stored without any problems, but I use ogr2ogr to import geometry files. Rob. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Ramsey Sent: Wednesday, March 12, 2008 10:14 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Does geometry field type have a size limit? 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 <[EMAIL PROTECTED]> 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--tp16006438 p16006438.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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
