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

[Edward Mac Gillavry]

Just to see what version of postgis and libraries you have available, execute the following query
SELECT PostGIS_Full_Version();
see http://www.postgis.org/docs/PostGIS_Full_Version.html

> Date: Tue, 3 Jan 2012 10:25:31 -0800
> From: jeremie.bryon at efusia.net
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Insert a point value : ST_GeometryFromText unknown function
> 
> 
> 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.
> 
> _______________________________________________
> 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/20120103/4e68decb/attachment.html>