On 10/25/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Stuart Grimshaw" <[EMAIL PROTECTED]> writes:
> I've installed the postgresql-contrib8.1 deb package to get at the
> earthdistance function, but it doesn't seem to be recognised, even
> after a restart of the server.
> Is there a final step I need to take after using apt-get to install?
Yeah, you have to run the SQL script included in the module to define
its functions within a particular database. Look for earthdistance.sql
among the files installed by the .deb (it's likely under /usr/share).
Thanks Tom, the .sql is stored in /usr/share/postgres/8.1/contrib
All sorted now.
--
-S
Sports Photography in South Yorkshire & Derbyshire
http://www.stuartgrimshaw.co.uk
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
