Re: Missing Earth Distance Functions Under Debian - Mailing list pgsql-admin

From Tom Lane
Subject Re: Missing Earth Distance Functions Under Debian
Date
Msg-id 16589.1161092253@sss.pgh.pa.us
Whole thread Raw
In response to Missing Earth Distance Functions Under Debian  ("Duncan McDonald" <duncan@gpats.com.au>)
List pgsql-admin
"Duncan McDonald" <duncan@gpats.com.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

pgsql-admin by date:

Previous
From: Sun Sun
Date:
Subject: Unsubscribe
Next
From: Thusitha Kodikara
Date:
Subject: Finding current SQL activity