Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 425229FB25F for ; Tue, 17 Oct 2006 02:04:15 -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 84077-07 for ; Tue, 17 Oct 2006 05:04:07 +0000 (UTC) X-Greylist: delayed 00:17:17.802969 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7658B9FB4B6 for ; Tue, 17 Oct 2006 02:04:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from tripitaka.dmz.gpats.com.au (global72.lnk.telstra.net [165.228.229.246]) by svr4.postgresql.org (Postfix) with ESMTP id D39F35AF992 for ; Tue, 17 Oct 2006 04:46:46 +0000 (GMT) Received: from firefly.intranet.gpats.com.au ([192.168.2.33] helo=Firefly) by tripitaka.dmz.gpats.com.au with smtp (Exim 4.50) id 1GZgqf-0007mL-T9 for pgsql-admin@postgresql.org; Tue, 17 Oct 2006 14:46:41 +1000 Message-ID: <007101c6f1a7$85990bb0$2102a8c0@Firefly> From: "Duncan McDonald" To: Subject: Missing Earth Distance Functions Under Debian Date: Tue, 17 Oct 2006 14:48:42 +1000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/105 X-Sequence-Number: 23408 Hi All. I was wondering whether someone could help me explain a weird PostgreSQL error I've encountered. I have two machines running Debian Sarge stable, the first has been operating as a database server for some time and the other I have just set up identically to run as a backup database. Both machines used the default database setup option during installation. Some of my scripts rely on the earth distance functions contained in the 'postgresql-contrib' package, but for some reason the backup PostgreSQL database does not recognise these functions. Eg. my latitude/longitude to distance converter, which runs fine on the main machine, generates this error message: "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. Does anyone have a theory why it would run on one and not the other and/or how I can get the earth distance functions working? Regards, -Duncan