<html><body>Dear Nicolas,<br><br>You are right, and Thank you very much for your answer.<br><br>Best regards...<br>
<br>
Ayhan Tekgul<br><br><blockquote style="border-left: solid 2px #000000; margin-left: 5px; padding-left: 5px">---- Original Message ----<br><b>From</b>: Nicolas Ribot <nicolas.ribot@gmail.com><br><b>To</b>: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><br><b>Sent</b>: Paz, Eki 2, 2011, 16:44 PM<br><b>Subject</b>: Re: [postgis-users] ERROR: invalid input syntax for integer: "POINT(389 418.12 4420549.100044)"<br><br>Hi,<br><br>There is a missing comma in geomFromText, between the geometry definition and the SRID value:<br><br>INSERT INTO pol_p (x, y,the_geom) VALUES (0, 0, GeomFromText('POINT(389418.12 4420549.100044)'<b><font class="Apple-style-span" size="6">, </font></b>-1));<br>
<br>Nicolas<br><br>> Hi,<br>><br>> I am trying to insert geometry information into a point table. But when I<br>> try to execute following query, I am getting " ERROR: invalid input syntax<br>> for integer: "POINT(389418.12 4420549.100044)" " message. I cannot get a<br>
> solution from my searches.<br>> Is there anyone who has solution to this problem?<br>><br>> QUERY :<br>><br>> INSERT INTO pol_p (x, y,the_geom) VALUES (0, 0,<br>> GeomFromText('POINT(389418.12 4420549.100044)' -1));<br>
><br>> ERROR :<br>><br>> ERROR: invalid input syntax for integer: "POINT(389418.12 4420549.100044)"<br>><br>> Here is my table SQL statement :<br>><br>> CREATE TABLE pol_p<br>> (<br>> gid serial NOT NULL,<br>
> the_geom geometry(Point,2097151),<br>> x double precision DEFAULT 0,<br>> y double precision DEFAULT 0,<br>> CONSTRAINT pol_p_pkey PRIMARY KEY (gid )<br>> )<br>> WITH (<br>> OIDS=TRUE<br>> );<br>
><br>> <br>> Best regards...<br>><br>> Ayhan Tekgul<br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br><br></blockquote></body></html>