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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
