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