> -----Message d'origine-----
> De : Michael Fuhr [mailto:mike@fuhr.org]
> Envoyé : lundi, mars 13, 2006 19:26
> À : Daniel Caune
> Cc : lucius.seneca@gmail.com; postgresql sql list
> Objet : Re: [SQL] 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"?
>
/usr/lib
PostgreSQL 8.1.2
> > > su postgres
> > > psql -f /usr/share/postgresql/8.1/contrib/tablefunc.sql <database>
>
> Or, omitting the su, psql -U postgres ....
>
> --
> Michael Fuhr