[postgis-users] Insert a point value : ST_GeometryFromText unknown function

efusien jeremie.bryon at efusia.net
Tue Jan 3 10:25:31 PST 2012


Hello,

I have a table "test" with 2 columns:
nom: text
localisation:	 point NULL

I make this query:

INSERT INTO "test" ("nom", "localisation")
VALUES ('myName', 'ST_GeometryFromText(POINT(2.5 49.0), 4326)');

But I have this error message:

Error in query: ERROR: invalid input syntax for type point:
"ST_GeometryFromText(POINT(2.5559 49.0083), 4326)"
LINE 2: VALUES ('myName', 'ST_GeometryFromText(POINT(2.5 49.0), ...


If I edit the Point syntax, sometimes an error says "ST_GeometryFromText
does not exists"...

Where am I wrong ?
May I have to enable some postGis functions ?
-- 
View this message in context: http://old.nabble.com/Insert-a-point-value-%3A-ST_GeometryFromText-unknown-function-tp33073860p33073860.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list