[postgis-users] Having trouble inserting into PostGIS

[Obe, Regina]

Seems okay to me.  I take it you are not just trying to stuff the below
in a geometry field and instead doing something like
 
geomfromtext('MULTILINESTRING((-74.65061950683594
39.87829780578613,-74.65056610107422 39.878252029418945))')
 
hope that helps,
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Peck, Brian
Sent: Tuesday, August 14, 2007 3:24 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Having trouble inserting into PostGIS



Hey all,

 

I'm trying to insert into my MultiLineString Geometry field in my
PostGIS databse and am getting the following error:

 

ERROR: parse error - invalid geometry

 

When I do a toString() on my MultiLineString I have the following output

 

MULTILINESTRING((-74.65061950683594 39.87829780578613,-74.65056610107422
39.878252029418945))

 

Anyone know why it doesn't like this?

 

Note: 

 - I'm using postgis 1.1.7 as it was the default with my Postgres
database

   - I tried upgrading but the installer for 1.2.1 had an error

 - My MultiLineString is made from a LineString[] made from a Point[]
with two points in it

 - I have successfully added non Geometry fields into my database

 - I'm using Hibernate to insert into my database

 




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070814/ece2b869/attachment.html>