[postgis-users] Insertings quite big MULTILINESTRING fails

[Suhr, Ralf]

Hi Sebastian,

did you use PgAdminII for display the data? PgAdminIII do not show large columns. You can test it by "SELECT id, ST_Length(your_geom), roadclass FROM MY_GEOMETRY_TABLE".
And one question. What is the reason for storing such big roads?

Mit freundlichen Grüßen,
gez. i.A. Ralf Suhr

--
Dipl. Ing. (FH) Ralf Suhr
Team Softwareentwicklung / Kompetenzzentrum Geo-Systeme 
Telefon: +49 345 581 7127
Telefax: +49 345 581 787127
E-Mail: Ralf.Suhr at itc-halle.de


IT-Consult Halle GmbH
Bornknechstraße 5
06108 Halle (Saale)

Eingetragen beim Amtsgericht
Stendal Handelsregister B
Nr. HRB-212984

Geschäftsführung:
Herr Axel von der Heyde
Herr Jörg Siebenhüner

Internet: http://www.itc-halle.de

 

-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Sebastian Marsky
Gesendet: Dienstag, 2. März 2010 15:26
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] Insertings quite big MULTILINESTRING fails

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