Обсуждение: ERROR: function geomfromtext(unknown)
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,
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
Вложения
On Fri, Apr 17, 2015 at 12:31 PM, Ankur Kaushik <ankurkaushik@gmail.com> wrote:
ERROR: function geomfromtext(unknown) does not existLINE 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 commandupdate route set route_string=GeomFromText(' LINESTRING(19.073210000000003 73.01268,19.07328 73.01181000000001,