Re: How to store directory like structures?

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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83