Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 5B1AD9FB362 for ; Tue, 17 Oct 2006 10:37:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 04552-08 for ; Tue, 17 Oct 2006 13:37:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 738E59FB326 for ; Tue, 17 Oct 2006 10:37:40 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9HDbXsf016590; Tue, 17 Oct 2006 09:37:33 -0400 (EDT) To: "Duncan McDonald" cc: pgsql-admin@postgresql.org Subject: Re: Missing Earth Distance Functions Under Debian In-reply-to: <007101c6f1a7$85990bb0$2102a8c0@Firefly> References: <007101c6f1a7$85990bb0$2102a8c0@Firefly> Comments: In-reply-to "Duncan McDonald" message dated "Tue, 17 Oct 2006 14:48:42 +1000" Date: Tue, 17 Oct 2006 09:37:33 -0400 Message-ID: <16589.1161092253@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/107 X-Sequence-Number: 23410 "Duncan McDonald" writes: > "ERROR: function ll_to_earth(numeric, numeric) does not exist > HINT: No function matches the given name and argument types. You may need > to add explicit type casts." > I've tried reinstalling the package in question but it had no effect. I think you forgot to execute the earthdistance.sql script to define the functions within the current database. regards, tom lane