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

From: Peter Pan <ganbaru83(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: OSX Postgres PL/Perl Problem with Finance::Quote/Options
Date: 2011-03-30 16:23:51
Message-ID: BAY157-w605AB6AF80FAF9C73D3C14A8BC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: badalex(at)gmail(dot)com
> Date: Wed, 30 Mar 2011 09:33:50 -0600
> Subject: Re: [GENERAL] OSX Postgres PL/Perl Problem with Finance::Quote/Options
> To: ganbaru83(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)org
>
> 2011/3/30 Peter Pan <ganbaru83(at)hotmail(dot)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?
>
> Skimming the source of Finance::Quote::Yahoo::USA (which seems to be
> what Finance::Quote uses when you ->fetch('nyse')) it looks like it
> makes a request to "http://finance.yahoo.com/d" with LWP. Maybe you
> could try using LWP directly and see if that complains?
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Looking through a couple of logs I finally found an indication for the error: could not lookup DNS configuration info service: (ipc/send) invalid destination port
this seems only to happen when executed with Postgres - i think its an underlying OSX problem in combination with postgres and found some entries online but no real solution for the problem.

cheers,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-03-30 16:26:25 Re: Date conversion using day of week
Previous Message Steve Crawford 2011-03-30 16:15:30 Re: Date conversion using day of week