Re: Missing Earth Distance Functions Under Debian

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Duncan McDonald" <duncan(at)gpats(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing Earth Distance Functions Under Debian
Date: 2006-10-17 13:37:33
Message-ID: 16589.1161092253@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Duncan McDonald" <duncan(at)gpats(dot)com(dot)au> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message binberati 2006-10-18 02:35:17 FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name"
Previous Message Sun Sun 2006-10-17 05:57:42 Unsubscribe