you need to load ltree into your database ! psql yourdb < ltree.sql
use 'locate ltree.sql' to find if ltree is installed
Yeah, I remember now having to do that, but the binary module definitely was here without having to do anything besides "emerge postgresql" :
[EMAIL PROTECTED] peufeu $ locate ltree.so /usr/lib/postgresql/ltree.so
[EMAIL PROTECTED] peufeu $ locate ltree.sql /usr/share/postgresql/contrib/ltree.sql
So just :
psql yourdb < /usr/share/postgresql/contrib/ltree.sql
And you should be OK.
Really this module is amazing. You can put a trigger on the table so that, for instance, the path is created automatically from the element name and the parent_id, that kind of things. I remember search was also really fast and you can use complex queries without CONNECT BY...
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
