Re: BUG #5034: plperlu problem with gethostbyname

On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima<diego_de_lima(at)hotmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5034
> Logged by:          Diego de Lima
> Email address:      diego_de_lima(at)hotmail(dot)com
> PostgreSQL version: 8.3.7
> Operating system:   Linux Fedora 10
> Description:        plperlu 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