Re: [Fwd: DBD::Pg on HP-UX 11.31 64bit]

From: "H(dot)Merijn Brand" <h(dot)m(dot)brand(at)xs4all(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndQuadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [Fwd: DBD::Pg on HP-UX 11.31 64bit]
Date: 2010-12-18 17:57:35
Message-ID: 20101218185735.441d193b@pc09.procura.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, 16 Dec 2010 12:56:12 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "H.Merijn Brand" <h(dot)m(dot)brand(at)xs4all(dot)nl> writes:
> > On Thu, 16 Dec 2010 12:31:21 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> So what I'm thinking is happening is that libpq expects size_t as
> >> the argument type, but it's getting linked against a libc that
> >> expects int as the argument type, and whatever HP is doing under
> >> the hood fails to cope with that case. You might try removing
> >> -D_XOPEN_SOURCE_EXTENDED from the template file --- I don't know if
> >> that will have any bad side-effects, but it's worth a try to build
> >> libpq that way.
>
> > I'll try that first after cleaning up my environment.
>
> I looked in the git history and found that I added
> -D_XOPEN_SOURCE_EXTENDED in a patch that made getaddrinfo work
> correctly:
> http://git.postgresql.org/gitweb?p=postgresql.git;a=commit;h=1da6eb7fdaa79a93972c290174bd7136672a894f
> So taking it out may indeed have unpleasant side-effects.

Which brings me to a rather awkward position.

A fresh built perl, using the same sockets that postgres uses (X/Open)
works perfectly fine with postgres, but now Oracle, DBD::Oracle also
freshly compiled with the same options however now doesn't work anymore
because of exactly the same reasons why DBD::Pg refused to work when I
started this quest.

As I use perl with DBD::Oracle and DBD::Pg at the same time to convert
between these two databases, there doesn't seem to be a way out.

My hopes in getting Oracle to change their policy is higher than IBM
changing user support, but still very close to zero.

How much are the postgres people willing to find a solution that would
force postgres to optional use BSD type sockets?

--
H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/
using 5.00307 through 5.12 and porting perl5.13.x on HP-UX 10.20, 11.00,
11.11, 11.23 and 11.31, OpenSuSE 10.1, 11.0 .. 11.3 and AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2010-12-18 20:49:10 Re: BUG #5791: Tables are not viewing through pgadmin
Previous Message Craig Ringer 2010-12-18 16:35:34 Re: BUG #5792: INSTALLER FAILS!!!