<html><body>Hi,<br><br>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.<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, 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></body></html>