[HACKERS] Testing for a shared library

2005-09-07 Thread Christopher Kings-Lynne
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

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Christopher Kings-Lynne
Is there any way of checking to see if a particular shared library is installed? eg. select is_shared_library('$libdir/tsearch2'); How well do you know the library you are looking for? You could just try creating a function from it and seeing if it fails. I know it pretty well, but it

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Kings-Lynne Sent: 07 September 2005 09:03 To: PostgreSQL-development Subject: [HACKERS] Testing for a shared library Hi, Is there any way of checking to see if a particular

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Dave Page
-Original Message- From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED] Sent: 07 September 2005 09:16 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Testing for a shared library Is there any way of checking to see if a particular shared library

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Teodor Sigaev
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

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Christopher Kings-Lynne
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

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Is there any way of checking to see if a particular shared library is installed? Try to LOAD it, perhaps. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget