<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<br>Just to see what version of postgis and libraries you have available, execute the following query<br><pre class="programlisting">SELECT PostGIS_Full_Version();<br></pre><div><div id="SkyDrivePlaceholder"></div>see http://www.postgis.org/docs/PostGIS_Full_Version.html<br><br>> Date: Tue, 3 Jan 2012 10:25:31 -0800<br>> From: jeremie.bryon@efusia.net<br>> To: postgis-users@postgis.refractions.net<br>> Subject: [postgis-users] Insert a point value : ST_GeometryFromText unknown function<br>> <br>> <br>> Hello,<br>> <br>> I have a table "test" with 2 columns:<br>> nom: text<br>> localisation: point NULL<br>> <br>> I make this query:<br>> <br>> INSERT INTO "test" ("nom", "localisation")<br>> VALUES ('myName', 'ST_GeometryFromText(POINT(2.5 49.0), 4326)');<br>> <br>> But I have this error message:<br>> <br>> Error in query: ERROR: invalid input syntax for type point:<br>> "ST_GeometryFromText(POINT(2.5559 49.0083), 4326)"<br>> LINE 2: VALUES ('myName', 'ST_GeometryFromText(POINT(2.5 49.0), ...<br>> <br>> <br>> If I edit the Point syntax, sometimes an error says "ST_GeometryFromText<br>> does not exists"...<br>> <br>> Where am I wrong ?<br>> May I have to enable some postGis functions ?<br>> -- <br>> View this message in context: http://old.nabble.com/Insert-a-point-value-%3A-ST_GeometryFromText-unknown-function-tp33073860p33073860.html<br>> Sent from the PostGIS - User mailing list archive at Nabble.com.<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div> </div></body>
</html>