Re: BUG #5034: plperlu problem with gethostbyname - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5034: plperlu problem with gethostbyname
Date
Msg-id 9085.1252191132@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5034: plperlu problem with gethostbyname  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #5034: plperlu problem with gethostbyname  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima<diego_de_lima@hotmail.com> wrote:
>> 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();

Don't have Fedora 10 installed anymore, but the F-11 packages should
be equivalent, and on F-11 I get this:

            test
-----------------------------
 $VAR1 = 'www.l.google.com';
 $VAR2 = 'www.google.com';
 $VAR3 = 2;
 $VAR4 = 4;
 $VAR5 = 'J}';
 $VAR6 = 'J}c';
 $VAR7 = 'J}g';
 $VAR8 = 'J}h';
 $VAR9 = 'J}i';
 $VAR10 = 'J}j';

(1 row)

I don't know enough about either gethostbyname or Data::Dumper
to figure out if this is sane or not.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5036: Advisory locks have unexpected behavior
Next
From: Tom Lane
Date:
Subject: Re: BUG #5010: perl iconv function returns ? character