From: Duncan McDonald <duncan@gpats.com.au>
To: pgsql-admin@postgresql.org
Subject: Missing Earth Distance Functions Under Debian
Date: Tue, 17 Oct 2006 14:48:42 +1000
Message-ID: <007101c6f1a7$85990bb0$2102a8c0@Firefly> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: duncan@gpats.com.au
Subject: Re: Missing Earth Distance Functions Under Debian
In-Reply-To: <007101c6f1a7$85990bb0$2102a8c0@Firefly>
References: <007101c6f1a7$85990bb0$2102a8c0@Firefly>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox