[postgis-users] ERROR: invalid input syntax for integer: "POINT(389 418.12 4420549.100044)"

[Nicolas Ribot]

Hi,

There is a missing comma in geomFromText, between the geometry definition
and the SRID value:

INSERT INTO pol_p (x, y,the_geom) VALUES (0, 0,
GeomFromText('POINT(389418.12 4420549.100044)'*, *-1));

Nicolas

> Hi,
>
> I am trying to insert geometry information into a point table. But when I
> try to execute following query, I am getting " ERROR:  invalid input
syntax
> for integer: "POINT(389418.12 4420549.100044)" " message. I cannot get a
> solution from my searches.
> Is there anyone who has solution to this problem?
>
> QUERY :
>
> INSERT INTO pol_p (x, y,the_geom) VALUES (0, 0,
> GeomFromText('POINT(389418.12 4420549.100044)' -1));
>
> ERROR :
>
> ERROR:  invalid input syntax for integer: "POINT(389418.12
4420549.100044)"
>
> Here is my table SQL statement :
>
> CREATE TABLE pol_p
> (
>   gid serial NOT NULL,
>   the_geom geometry(Point,2097151),
>   x double precision DEFAULT 0,
>   y double precision DEFAULT 0,
>   CONSTRAINT pol_p_pkey PRIMARY KEY (gid )
> )
> WITH (
>   OIDS=TRUE
> );
>
>
> Best regards...
>
> Ayhan Tekgul
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111002/f6b032b8/attachment.html>