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