Re: Testing for a shared library

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
> 
>