From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Testing for a shared library |
Date: | 2005-09-07 09:07:42 |
Message-ID: | 431EADDE.1060801@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
No, I want to check that the shared library exists (eg. the slony
libraries) BEFORE executing the slony sql script that creates all the
objects.
Chris
Teodor Sigaev wrote:
> As you know, presence of shared library doesn't mean precense of module
> in db :).
>
>
> You can try selecting:
>
> # select count(*) from pg_opclass where opcname = 'tsvector_ops';
>
> or, more general,
>
> # select count(*) from pg_proc where probin = '$libdir/tsearch2';
>
>
> But not all modules adds new function...
>
>
>
>
> Christopher Kings-Lynne wrote:
>
>> Hi,
>>
>> Is there any way of checking to see if a particular shared library is
>> installed?
>>
>> eg. select is_shared_library('$libdir/tsearch2');
>>
>> If not, can we please have one :D
>>
>> This will greatly help in GUI apps like phpPgAdmin...
>>
>> Chris
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2005-09-07 11:51:05 | PL/PGSQL and drop/create table |
Previous Message | Teodor Sigaev | 2005-09-07 08:57:46 | Re: Testing for a shared library |