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

strk at refractions.net strk at refractions.net
Tue Aug 30 03:01:06 PDT 2005

On Tue, Aug 30, 2005 at 11:06:30AM +0200, Gerhard Engel wrote:
> 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?

I'd think 'sname' is an array type, can you verify ?

More information about the postgis-users mailing list