[postgis-users] Insertings quite big MULTILINESTRING fails

[Sebastian Marsky]

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

PTV AG
Tel. : +49-(0)721-9651-8-257
Fax  : +49-(0)721-9651-8-299
email: Sebastian.Marsky at ptv.de
.........................................................................
PTV
Planung Transport Verkehr AG
Stumpfstraße 1
76131 Karlsruhe
Germany
http://www.ptv.de
.........................................................................
PTV Planung Transport Verkehr AG
Hauptsitz / Headquarters: Karlsruhe
Vorstand / Board of Directors: Dr.-Ing. Hans Hubschneider, Dr. Joachim 
Schmidt,
Dr.-Ing. Thomas Schwerdtfeger, Harald Holberg, Thomas Haupt, Vincent Kobesen
Vorsitzender des Aufsichtsrates / Chairman of the Supervisory Board: Dr. 
Volkmar Mair
Handelsregister / Companies' Register (HRB-Nr): 109262
Amtsgericht / District Court: Mannheim