Re: getting access to geodistance (what do I need to install/enable) in an existing db install

Michael,
     I found the files cube.sql and earthdistance.sql in the contrib
directory on my windows box. I put it on my debian box and then
psql'ed into the db and did \i cube.sql and thats how I got the
message.
 But I am still stumped as to how to get it to work.
Additionally, I was trying to install postgis on the debian box and
cannot find the contrib directory.

thanks for your help
-assad



On 1/11/06, Michael Fuhr <mike@fuhr.org> wrote:
> [Please copy the mailing list on replies.]
>
> On Wed, Jan 11, 2006 at 08:02:56PM -0700, Assad Jarrahian wrote:
> >    I tried that, but it said type cube does not exists. I tried
> > looking around and could not find the file where CREATE type cube is
> > in.
>
> cube and earthdistance are contributed modules; in the PostgreSQL
> source code they're under the contrib directory.  If you're using
> pre-built packages then look through the available packages for
> something with a name like postgresql-contrib, pgsql-contrib, etc.
> The required SQL files and shared objects should be in that package.
>
> --
> Michael Fuhr
>