Re: [SQL] dynamically loaded functions

2005-07-12 Thread Michael Fuhr
On Mon, Jul 11, 2005 at 08:16:17PM -0700, TJ O'Donnell wrote: > > CREATE or REPLACE FUNCTION cansmiles(varchar) RETURNS varchar >AS 'gnova', 'oe_cansmiles' LANGUAGE 'c' IMMUTABLE STRICT; > requires preloading of oe_chem.so to work. > > Is there any way I can associate oe_cansmiles with 2 .so's

[SQL] dynamically loaded functions

2005-07-12 Thread TJ O'Donnell
I've written some c-functions which depend on my code (gnova.so) as well as a third-party library of functions (oe_chem.so). Up until now, I've been preloading (in postgresql.conf) both .so's and it all works fine. To make it easier for my users to install my stuff, I'd like to avoid the preloadi