Re: ERROR: function geomfromtext(unknown)

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: function geomfromtext(unknown)
Date: 2015-04-17 07:08:28
Message-ID: 1429254508.25074.1.camel@gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2015-04-17 10:42:08 Re: ERROR: function geomfromtext(unknown)
Previous Message Ankur Kaushik 2015-04-17 07:01:21 ERROR: function geomfromtext(unknown)