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

[Gerhard Engel]

The postgis version is 1.03

No, there is no other field defined as array-type - sname = varchar(80).


Gerhard




>Today's Topics:
>
>    1. Re: Why does this take almost 3 hours? (Paul Ramsey)
>    2. RE: Seamlessly handling lat/long coordinates (Craig Miller)
>    3. Re: shp2pgsql segfault and gdb (Jorg Heymans)
>    4. Adding point Data to a geometry table (Gerhard Engel)
>    5. Re: Adding point Data to a geometry table (Nicolas Ribot)
>    6. Re: Adding point Data to a geometry table (strk at refractions.net)
>
>
>----------------------------------------------------------------------
>
>Date: Tue, 30 Aug 2005 11:16:34 +0200
>From: Nicolas Ribot <nicky666 at gmail.com>
>Subject: Re: [postgis-users] Adding point Data to a geometry table
>To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>Message-ID: <28de5e310508300216435572c5 at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
> > 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
>
>
>------------------------------
>
>Message: 6
>Date: Tue, 30 Aug 2005 12:01:06 +0200
>From: strk at refractions.net
>Subject: Re: [postgis-users] Adding point Data to a geometry table
>To: postgis-users at postgis.refractions.net
>Message-ID: <20050830100106.GC25178 at keybit.net>
>Content-Type: text/plain; charset=us-ascii
>
>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 ?
>--strk;
>
>
>------------------------------