Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 388649FB2E6 for ; Wed, 18 Oct 2006 20:35:46 -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 37278-10 for ; Wed, 18 Oct 2006 23:35:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3EADD9FA354 for ; Wed, 18 Oct 2006 20:35:42 -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 D631D5AF03C for ; Wed, 18 Oct 2006 23:35:40 +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 1GaKwf-0004ew-MH; Thu, 19 Oct 2006 09:35:33 +1000 Message-ID: <01e701c6f30e$63f63790$2102a8c0@Firefly> From: "Duncan McDonald" To: "Tom Lane" Cc: References: <007101c6f1a7$85990bb0$2102a8c0@Firefly> <16589.1161092253@sss.pgh.pa.us> Subject: Re: Missing Earth Distance Functions Under Debian Date: Thu, 19 Oct 2006 09:37:35 +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/115 X-Sequence-Number: 23418 Hi Tom, Thanks for the reply. No I didn't run the earthdistance.sql script on the backup database, is this included with the standard PostgreSQL package? If not, would you mind letting me know how/where to obtain it? I'm relatively new to PostgreSQL administration so I apologise in advance if this is an obvious question. Regards, -Duncan ----- Original Message ----- From: "Tom Lane" To: "Duncan McDonald" Cc: Sent: Tuesday, October 17, 2006 11:37 PM Subject: Re: [ADMIN] Missing Earth Distance Functions Under Debian ... > I think you forgot to execute the earthdistance.sql script to define > the functions within the current database. > > regards, tom lane >