From: | "Stuart Grimshaw" <stuart(dot)grimshaw(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Enableing contrib modules on Debian |
Date: | 2006-10-26 08:17:26 |
Message-ID: | f916d72a0610260117m51751cbfgdf13702e88e2764b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/25/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Stuart Grimshaw" <stuart(dot)grimshaw(at)gmail(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2006-10-26 09:18:45 | Re: Reducing pg_dump & pg_restore times |
Previous Message | Fip | 2006-10-26 07:25:58 | grouping excluding some text results |