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 <[EMAIL PROTECTED]> 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
>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
