Re: How to store directory like structures?

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Axel Straschil <axel(at)straschil(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to store directory like structures?
Date: 2005-04-03 19:24:56
Message-ID: Pine.GSO.4.62.0504032323370.15865@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, 3 Apr 2005, Axel Straschil wrote:

> Hello!
>
>> On gentoo (at least on my box) it's installed by default in 8.0, I
>> believe it was installed by default, too, on 7.4.X
>
> Tried with gentoo just under 7.4.x and 8.0.1:
>
> axel=# CREATE TABLE test ( path ltree);
> ERROR: type "ltree" does not exist
>
> Any idea?

you need to load ltree into your database !
psql yourdb < ltree.sql

use 'locate ltree.sql' to find if ltree is installed

>
> Thanks,
> AXEL.
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-04-03 19:57:29 Re: How to store directory like structures?
Previous Message Axel Straschil 2005-04-03 19:03:09 Re: How to store directory like structures?