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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
