Forum OpenACS Q&A: Re: new to acs, need help with xowiki toc

Collapse
8: Re: new to acs, need help with xowiki toc (response to 1)
Posted by Nima Mazloumi on 04/29/08 05:04 PM
I forgot to mention that this will only work if postgres is installed on the same box.
Collapse
9: Re: new to acs, need help with xowiki toc (response to 8)
Posted by Matthew Smith on 04/29/08 05:15 PM
I am having trouble resolving the pth to use to run the script. Here are the results of "exec locate ltree.sql":
-------------------------------------------------------------
/usr/local/src/postgresql-7.4.6/contrib/ltree/ltree.sql.in
/usr/local/src/postgresql-7.4.6/contrib/ltree/sql/ltree.sql
/usr/local/src/postgresql-8.2.1/contrib/ltree/ltree.sql.in
/usr/local/src/postgresql-8.2.1/contrib/ltree/uninstall_ltree.sql
/usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql
/usr/local/src/postgresql-8.2.1-pre-upgrade/contrib/ltree/ltree.sql.in
/usr/local/src/postgresql-8.2.1-pre-upgrade/contrib/ltree/uninstall_ltree.sql
/usr/local/src/postgresql-8.2.1-pre-upgrade/contrib/ltree/sql/ltree.sql
-------------------------------------------------------------

I assume I want to run this one:
/usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql

I have tired the following but just get and error:
exec psql </usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql>
exec psql<ltree.sql>
exec psql<./usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql>

I am not really sure of the directory structure I am accessing so don't know how to resolve it.

Thank you.