Re: connectby documentation

On Mon, Mar 13, 2006 at 06:38:14PM -0500, Daniel Caune wrote:
> I provide hereafter a description about how to install the function
> connectby (I didn't find such documentation and I don't know where to
> write this documentation):

README.tablefunc contains instructions on how to load the module
into a database.

> > apt-get install postgresql-contrib-8.1
> > emacs /usr/share/postgresql/8.1/contrib/tablefunc.sql
> 
> Replace "$libdir" by "/usr/lib/postgresql/8.1/lib/tablefunc.so" (I
> suggest to modifying only a copy of this file).

That shouldn't be necessary unless the package installed the shared
objects somewhere other than where the database was expecting.
What's the output of "pg_config --libdir --version"?

> > su postgres
> > psql -f /usr/share/postgresql/8.1/contrib/tablefunc.sql <database>

Or, omitting the su, psql -U postgres ....

-- 
Michael Fuhr