| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Daniel Caune <daniel(dot)caune(at)ubisoft(dot)com> |
| Cc: | lucius(dot)seneca(at)gmail(dot)com, postgresql sql list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: connectby documentation |
| Date: | 2006-03-14 00:25:48 |
| Message-ID: | 20060314002548.GA90894@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Caune | 2006-03-14 00:29:44 | Re: connectby documentation |
| Previous Message | Daniel Caune | 2006-03-13 23:38:14 | Re: connectby documentation |