From: Oleg Bartunov <oleg@sai.msu.su>
To: Axel Straschil <axel@straschil.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to store directory like structures?
Date: Sun, 3 Apr 2005 23:24:56 +0400 (MSD)
Message-ID: <Pine.GSO.4.62.0504032323370.15865@ra.sai.msu.su> (raw)
In-Reply-To: <slrnd50fii.gfo.axel@m2.sine>
References: <slrnd4vghu.tp.axel@m2.sine>
<slrnd509sg.fls.axel@m2.sine>
<Pine.GSO.4.62.0504032059420.15865@ra.sai.msu.su>
<op.son4ths6th1vuj@localhost>
<slrnd50fii.gfo.axel@m2.sine>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oleg@sai.msu.su, axel@straschil.com
Subject: Re: How to store directory like structures?
In-Reply-To: <Pine.GSO.4.62.0504032323370.15865@ra.sai.msu.su>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox