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