> Subject: Re: [GENERAL] OSX Postgres PL/Perl Problem with Finance::Quote/Options > From: vibhor.kumar@enterprisedb.com > Date: Wed, 30 Mar 2011 03:01:29 +0530 > CC: pgsql-general@postgresql.org > To: ganbaru83@hotmail.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. > > > > Enviro nment: > > - 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.kumar@enterprisedb.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.
