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

[Nicolas Ribot]

> 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?
> 

Hello Gerhard,

I don't thing the problem comes from the "insert into" query. I tested the 
('Schluchsee', GeomFromEWKT('SRID=-1;POINT(8.2 47.8)')) part, and it
seems to be ok.
Is it possible that your station table has other columns whose type
could be array or something like that, with default values that are
not correctly generated when inserting some data ?

(btw, what postgis version do you use ? You can use:
 select postgis_full_version() to retrieve it.

Nicolas