Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group