Re: ERROR: function geomfromtext(unknown) - Mailing list pgsql-admin

Hi,

On Fri, 2015-04-17 at 12:31 +0530, Ankur Kaushik wrote:
> ERROR:  function geomfromtext(unknown) does not exist
> LINE 1: update route set route_string=GeomFromText(' LINESTRING(19.0...
>                                       ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
>
>
> Facing this Error while executing Below command
>
> update route set route_string=GeomFromText(' LINESTRING(19.073210000000003
> 73.01268,19.07328 73.01181000000001,

I think it would be st_geomfromtext, and that one comes with PostGIS.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR