Re: OSX Postgres PL/Perl Problem with Finance::Quote/Options

> Subject: Re: [GENERAL] OSX Postgres PL/Perl Problem with Finance::Quote/Options
> From: vibhor(dot)kumar(at)enterprisedb(dot)com
> Date: Wed, 30 Mar 2011 03:01:29 +0530
> CC: pgsql-general(at)postgresql(dot)org
> To: ganbaru83(at)hotmail(dot)com
>
>
> On Mar 29, 2011, at 9:11 PM, Peter Pan wrote:
>
> > I use two Perl modules Finance::Quote and Finance::QuoteOptions in a stored PL/Perl procedure which run without problems on a standard LINUX environment (currently in production on CentOS5). Unfortunately on OSX it seems not to be able to properly connect and retrieve the data from Yahoo.
> >
> > Using the same code in a local perl file (under db user) it works without problems, but fails in the stored procedure. I don't get any compilation errors during import or execution and also no exceptions while the code is executed. As mentioned, the same function works fine under Linux.
> >
> > Environment:
> > - OSX 10.6.7
> > - Postgres 9.0.2 (compiled from source / config options --with-openssl --with-perl --with-libraries=/opt/local/lib --with-includes=/opt/local/include / readline was installed via ports)
> > - Perl 5.12.3 (compled from source under /usr/local/ linked via enviromentab le variables in .profile / config options ./configure.gnu -des -Duseshrplib --prefix=/usr/local/perl5)
>
> Any Error Message?
>
> Thanks & Regards,
> Vibhor Kumar
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
> vibhor(dot)kumar(at)enterprisedb(dot)com
> Blog:http://vibhork.blogspot.com
>

Unfortunately none at all, it just fails during the fetch and can't find any error messages anywhere. As stated, the same module works without problems in a local separate perl script.

Any ideas?

cheers,