[postgis-users] Does geometry field type have a size limit?
robe.dnd at cityofboston.gov
Wed Mar 12 12:57:56 PDT 2008
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
on those blank ones - if it returns a number you should be fine.
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Sent: Wednesday, March 12, 2008 12:50 PM
To: postgis-users at postgis.refractions.net
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
when it inserts some of the larger polygons it fails to insert the
I tried it using the shp2pgsql and I tried it using my own code in C#
have even tried executing the SQL in the pgAdmin III Query function and
three have the exact same results the record gets inserted but the
field is null and it only happens on those records that have a lot of
that make up the polygon, I created several test to try and determine
many points were too much for it and I hit upon 1365 seemed to be the
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?
View this message in context:
Sent from the PostGIS - User mailing list archive at Nabble.com.
postgis-users mailing list
postgis-users at postgis.refractions.net
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.
More information about the postgis-users