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

[efusien]

Thank you Edward,

With the query :
"SELECT PostGIS_Full_Version();"

I have this error :
ERROR:  function postgis_full_version() does not exist

Does it mean I have to install some other features ?



Edward Mac Gillavry wrote:
> 
> 
> 
> 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
>  		 	   		  
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/Insert-a-point-value-%3A-ST_GeometryFromText-unknown-function-tp33073860p33074478.html
Sent from the PostGIS - User mailing list archive at Nabble.com.