Sender: lockhart@hub.org
Message-ID: <37B97202.B61B8626@alumni.caltech.edu>
Date: Tue, 17 Aug 1999 14:30:26 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
MIME-Version: 1.0
To: "Mengelbier, Magnus" <Magnus.Mengelbier@clinicaldatacare.com>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Error using Perl interface
References: 
 <81F0C610BC68D2118F110008C7242DE5327480@luex1.clinicaldatacare.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> We wonder if anyone has found and resolved an error we recieve when trying
> to connect to a PostgreSQl 6.5.1 database with perl 5.0053.
...
> We are running Red Hat 6.0 standard installation with PostgreSQL 6.5.1 and
> the perl interface that was available. We opted to install the binaries
> instead of compiliing the source ourselves.  We are running Perl 5.0053 that
> was installed with the system installation.

Which "binaries" did you install, and from what source? RedHat
currently uses a cheat to install perl (and a few other kinds of
things) in that they stuff *all* generated code into the "version
neutral" perl library area. So something built for perl-5.004x, as
were rpms posted at postgresql.org, will have been built and linked
for that version, but perl doesn't know that.

Anyway, I'm guessing that if you pick up the src.rpm for Postgres, and
build it on your system, it will start working.

I'm sure that there is a better way, like

  rpm --rebuild postgresql-6.5.1-src.rpm

but I haven't actually tried running that way since I've been building
the rpms. I do know that something like

  rpm -ivv postgresql-6.5.1-src.rpm
  cd /usr/src/redhat/SPECS
  rpm -ba postgresql-6.5.1.spec
  cd ../RPMS/i386

will get you new rpms for your platform, built against your tools.

Good luck.

                      - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California