From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Querying $libdir |
Date: | 2003-09-03 00:29:08 |
Message-ID: | Pine.LNX.4.21.0309030124000.32652-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Replying to myself...
On Wed, 3 Sep 2003, Nigel J. Andrews wrote:
>
> The subject says it really. Is there a way to query the value of $libdir, and I
> don't mean the dynamic_library_path GUC?
>
> I ask because, I have scripts to create databases and I've come to make
> adjustments to load tsearch2. Now contrib/tsearch2 installs itself into $libdir
> with tsearch2.sql installed as $libdir/contrib/tsearch2.sql...
I got that wrong, it actually installs tsearch2.sql into
$libdir/../share/contrib/ without specifically setting a different location for
shared files.
However, I also note that the functions are installed into public schema. That
looked fine when I first checked that it wasn't polluting namespaces in the
search path. Unfortunately, the database I'm looking at at the moment doesn't
have public in the user's search paths. Therefore, I'm going to have to bring
tsearch2 into my own release procedures, something not made easy by it only
being compilable within the contrib directory of the main source tree.
--
Nigel J. Andrews
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2003-09-03 00:31:51 | Re: pg_autovacuum |
Previous Message | Kuldeep Tanna | 2003-09-03 00:13:52 | Crosstab function Problem |