Forum OpenACS Development: Re: ltree and tsearch2.sql

Collapse
2: Re: ltree and tsearch2.sql (response to 1)
Posted by Gustaf Neumann on 04/24/07 08:31 AM
tsearch2 and ltree depend on the postgres version, so including these in the OpenACS repository opens another can of worms. In my opinion the best places to add these are
- at the end of the postgres compilation (compile both modules and add them to template1), or
- after createdb (make sure the modules are compiled and run both sql scripts against the new database)

Not sure, which binary distributions come with these database modules compiled.

Collapse
4: Re: ltree and tsearch2.sql (response to 2)
Posted by Malte Sussdorff on 04/24/07 03:56 PM
Good points, thanks. So I will just leave them in the template1 as per my installations instructions. It is just causing (not to be concerned of) errors when you load a dumpfile into a freshly created database (which is based on template1) as the basic tables already exist. But well, that is the downside of the convenience not to have them to load after createdb (which might actually be on a different remote server). Thanks for the quick reply.