[postgis-users] Adding point Data to a geometry table

Gerhard Engel Gerhard.Engel at sbg.ac.at
Tue Aug 30 02:06:30 PDT 2005


Hello,

these are my first steps with postgis/postgres on an window XP machine.

I try to insert data into an geometry table altered successfully with:
SELECT AddGeometryColumn('public', 'station','station_geom', -1, 'POINT', 2)

Mycommand is:
INSERT INTO public.station (sname,station_geom)
         VALUES ('Schluchsee', GeomFromEWKT('SRID=-1;POINT(8.2 47.8)'))

The error message is: "ERROR:  array value must start with "{" or dimension 
information". I do not understand where the "{" should be written. 
According to the documentation I browsed through, my syntax should be ok.

Any ideas?

Thank you in advance,
Gerhard




----------------------------------
Gerhard Engel
Gerhard.Engel at sbg.ac.at
Z_GIS Zentrum für Geoinformatik * Universität Salzburg * Hellbrunnerstraße 
34 * A-5020 Salzburg
tel. +43 662 8044-5223 * fax +43 662 8044-525
web: http://www.zgis.at
----------------------------------- 




More information about the postgis-users mailing list