Re: BUG #5034: plperlu problem with gethostbyname

On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima<diego_de_lima@hotmail.com> wr=
ote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05034
> Logged by: =A0 =A0 =A0 =A0 =A0Diego de Lima
> Email address: =A0 =A0 =A0diego_de_lima@hotmail.com
> PostgreSQL version: 8.3.7
> Operating system: =A0 Linux Fedora 10
> Description: =A0 =A0 =A0 =A0plperlu problem with gethostbyname
> Details:
>
> The gethostbyname Perl internal function doesn't work properly on 8.3.7,
> returning "1" instead of the desired data array.
>
> On Postgres 8.2.x it works perfectly.
>
> Using Perl v5.10.0.
>
> Using Fedora 10 default rpm packages, all updated last month via yum.

I can't reproduce this on a clean build of 8.3.7 or on a clean build
of CVS HEAD, both against perl 5.10.0, so I don't think this is a
PostgreSQL bug.  I'm guessing you have a bug in your code someplace.
Here's the test case I used.

create or replace function test() returns varchar as $$use
Data::Dumper; Dumper(gethostbyname("www.google.com"));$$ language
plperlu;

select test();

...Robert