pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Daniel Caune <daniel.caune@ubisoft.com>
Cc: lucius.seneca@gmail.com, postgresql sql list <pgsql-sql@postgresql.org>
Subject: Re: connectby documentation
Date: Mon, 13 Mar 2006 17:25:48 -0700
Message-ID: <20060314002548.GA90894@winnie.fuhr.org> (raw)
In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D201C6B1F2@UBIMAIL1.ubisoft.org>
References: <1E293D3FF63A3740B10AD5AAD88535D201C6B1F2@UBIMAIL1.ubisoft.org>

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



view thread (14+ messages)  latest in thread

Message-ID: <20060314002548.GA90894@winnie.fuhr.org>
Permalink:  ../20060314002548.GA90894@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20060314002548.GA90894@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mike@fuhr.org, daniel.caune@ubisoft.com
  Subject: Re: connectby documentation
  In-Reply-To: <20060314002548.GA90894@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox