Missing Earth Distance Functions Under Debian

From: "Duncan McDonald" <duncan(at)gpats(dot)com(dot)au>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Missing Earth Distance Functions Under Debian
Date: 2006-10-17 04:48:42
Message-ID: 007101c6f1a7$85990bb0$2102a8c0@Firefly
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sun Sun 2006-10-17 05:57:42 Unsubscribe
Previous Message Michael Fuhr 2006-10-17 00:33:19 Re: openssl config?