Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yj0OH-0001gH-Rb for pgsql-admin@arkaria.postgresql.org; Fri, 17 Apr 2015 07:08:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yj0OG-00053Z-SM for pgsql-admin@arkaria.postgresql.org; Fri, 17 Apr 2015 07:08:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yj0OF-00053I-Vi for pgsql-admin@postgresql.org; Fri, 17 Apr 2015 07:08:40 +0000 Received: from ns3.gunduz.org ([107.170.88.27] helo=ns1.gunduz.org) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yj0OB-0006nE-0y for pgsql-admin@postgresql.org; Fri, 17 Apr 2015 07:08:38 +0000 Received: from asus-laptop-03 (unknown [5.25.164.113]) (using TLSv1.2 with cipher AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by ns1.gunduz.org (Postfix) with ESMTPSA id AEB3E42435; Fri, 17 Apr 2015 07:08:32 +0000 (UTC) Message-ID: <1429254508.25074.1.camel@gunduz.org> Subject: Re: ERROR: function geomfromtext(unknown) From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= To: Ankur Kaushik Cc: pgsql-admin@postgresql.org Date: Fri, 17 Apr 2015 10:08:28 +0300 In-Reply-To: References: Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-RrHRi/Cmzvk29ojDo9aP" X-Mailer: Evolution 3.12.11 (3.12.11-1.fc21) Mime-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --=-RrHRi/Cmzvk29ojDo9aP Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=3DGeomFromText(' LINESTRING(19.0... > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. >=20 >=20 > Facing this Error while executing Below command >=20 > update route set route_string=3DGeomFromText(' LINESTRING(19.073210000000= 003 > 73.01268,19.07328 73.01181000000001, I think it would be st_geomfromtext, and that one comes with PostGIS. Regards, --=20 Devrim G=C3=9CND=C3=9CZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR --=-RrHRi/Cmzvk29ojDo9aP Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAABAgAGBQJVMLFsAAoJENjDPf6Sz261YvMP/Rgm7jPJAQuIplr5sL2ojm1Q IUoO4mFVnG7TSZ9AF0NYF0nRD6At5co3yEoWm90yQz98n1r8cOYZPABdTw8/lEm+ vnSEUphaDo4kQDDQzlnLmdgo4l6wjmBjhmK7MnUoZbZXVSNiLe1We3mvm4HlFeIe ZJWM+LF1pNmLYYILdPVo7Nzu6NTUvEZWYS+hV0b+fBKjygh6NUFUzvA809EoXncL yUD/r1fREPn/5kZ8TgupUwe/9S6CtqLk3r9SuZ7WI5q/fa5AY0wjQeX+x0BfY3Re fZsBYGxwC1NYBnTam6qZAvSas1AX0X1604BQ65LfG3Ivn+BgyTN/9TmFnniz0IMp 3D292OIr4l5QcAOLbZgRCyQXGfZufS45xJmKevTzGsIXj8nCJqe5Rj6UsVwUwuXQ WcRt/p9027biUDrz+b5X5PfDNngpJMENSxMXE9OIdpFSCwfA9HHZfbVex98OI/dv J90RhMmP5/ae299cUBoMIaS99gPdFQ2Q/nZS6kMLO0xntuKWF+SDdBC/ncdmzfGt 8LBJuZJE5myzetP2amxDCtHfRebwOMRsewyHxQXJXrBHw92d9D7KEVJhNd+hBwx9 sGCvoibYnDJJqJHDqgaXwOOI9VfYTg2i/MrnFqxa2/MCQvR06KjKk/dnzirtGJBu NtBXjqHoGjxhpxNZqSAd =N6Dv -----END PGP SIGNATURE----- --=-RrHRi/Cmzvk29ojDo9aP--