Here is the DDL for Table creation:
CREATE TABLE gtest ( ID int4, NAME varchar(20) );
SELECT AddGeometryColumn('', 'gtest','geom',-1,'LINESTRING',2);
Thanks, Majid-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Neufeld Sent: March 10, 2010 11:48 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] FW: Inserting value into geometry column error: Array value must start with "{" or dimension. What's the DDL for your guest table? On 3/10/2010 8:29 AM, Majid Kazemi wrote: > *From:* Majid Kazemi > *Sent:* March 10, 2010 11:02 AM > *To:* '[email protected]' > *Subject:* Inserting value into geometry column error: Array value > must start with "{" or dimension. > > Hello all; > Thanks for everyone help. I finally managed to install and configure > Postgis. > Now, I am trying to insert the following into a table with Geom column. > > INSERT INTO guest(ID, NAME, GEOM) > > VALUES (1,'First Geometry',ST_GeomFromText('LINESTRING(2 3,4 5,6 5,7 > 8)', -1)); > > I am receiving the following error: > > Array value must start with "{" or dimension. > > your help will highly be appreciated. > > Thanks, Majid > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
