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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
