[postgis-users] Insertings quite big MULTILINESTRING fails

[Charles Galpin]

This came up the other day. It's a display limitation of spql or pgadmin. Try this

select st_length(the_geom), st_asText(st_startpoint(the_geom)), st_asText(st_endpoint(the_geom)) from MY_GEOMETRY_TABLE  limit 1;

You should see all is well.

hth
charles

On Mar 2, 2010, at 9:26 AM, Sebastian Marsky wrote:

> hi,
> 
> I'm trying to insert quite big MULTILINSTRING objects with about 1000 points. The INSERT-statement is in a form like:
> 
> INSERT INTO MY_GEOMETRY_TABLE VALUES (1, 2, GeomFromText('MULTILINESTRING((11.5211 48.08109, [...],11.51651 48.08071))',4326));
> 
> (first column being the PK, second an attribute (roadclass)).
> 
> When I execute this one, no error occurs (even in the Postgres logs), but the 'geometry' column is just empty atferwards!
> 
> I experimented a bit, and noticed that to the limit of about 170 points everything works, and above that, the problem shows up.
> 
> So I wonder if there is any hard limit on number of points for a MULTILINESTRING? Or could something go wrong while parsing the string cause it exceeds some char array size?
> 
> 
> -- 
> 
> Sebastian Marsky