[postgis-users] linestring limits

[Hugues François]

Hello,

What do y ou mean by opening the attributes table and looked at geometries ? With pgadmin there are limitations on number of characters displayed. I dont know with qgis. Did y ou open the table as spatial data un qgis or openjump ? Does the expected number of geometries appear ?

Hugues

"Clay, Bruce" <bclay at ball.com> a écrit :

Is there a limit to the number of points or character linelengh that can be used to create a linestring?
 
I used QGis to trace some roads then exported the layer as a KML file.  I wrote a script to create a table and add attributes to the table then copied the coordinates from the KML into the script after manipulating the punctuation and white space.  When I open the attributes table only some of the lines showed geometry.  I played with the script for a while and it seemd like there was a limit to somewhere around 4,000 characters.  It did not seem to be a hard limit at 4,000 but it was pretty close.
 
If there is a limit is there a way to change the configuration to get past this?  Some of the strings used with STY_GeomFromText where around 7,000 characters.
 
Bruce



This message and any enclosures are intended only for the addressee.  Please 
notify the sender by email if you are not the intended recipient.  If you are 
not the intended recipient, you may not use, copy, disclose, or distribute this 
message or its contents or enclosures to any other person and any such actions 
may be unlawful.  Ball reserves the right to monitor and review all messages 
and enclosures sent to or from this email address.