Hi

I have updated my RedHat Linux installation to v 9.0, and now run
Postgres-7.0.3-8 and Perl-5.8.0-88. I am trying to install v 1.9.0 of
pgsql_perl5.

According to instructions I have logged in as user postgres, and set
up and exported the environment variables POSTGRES_INCLUDE=/usr/lib
and POSTGRES_LIB=/usr/include/pgsql (which is where the libpq.so and
libpq-fe.h are found)

I run Makefile.PL OK, and it generates Makefile without reporting
errors. But when I run make, it comes up with a raft of errors and
warnings. The reportedly absent file libpq-fe.h is definitely there
and readable as user postgres.

I have shown below some file content and output that may be
informative.

Can anybody offer any help? Could it be a version problem?

---------------------------------------------------------------
The following is the first few lines of the generated Makefile
---------------------------------------------------------------

# This Makefile is for the Pg extension to perl.
#
# It was generated automatically by MakeMaker version
# 6.03 (Revision: 1.63) from the contents of
# Makefile.PL. Don't edit this file, edit Makefile.PL instead.
#
# ANY CHANGES MADE HERE WILL BE LOST!
#
# MakeMaker ARGV: ()
#
# MakeMaker Parameters:

# INC => q[-I/usr/lib]
# LIBS => [q[-L/usr/include/pgsql -lpq]]
# NAME => q[Pg]
# OBJECT => q[Pg$(OBJ_EXT)]
# VERSION_FROM => q[Pg.pm]

---------------------------------------------------------------
The following is the first few lines of Pg.pm
---------------------------------------------------------------

#-------------------------------------------------------
#
# $Id: Pg.pm,v 1.18 2000/04/04 19:41:52 mergl Exp $
#
# Copyright (c) 1997, 1998 Edmund Mergl
#
#-------------------------------------------------------

package Pg;

#use strict;
use Carp;
use vars qw($VERSION @ISA @EXPORT $AUTOLOAD);

require Exporter;
require DynaLoader;
require AutoLoader;
require 5.003;

@ISA = qw(Exporter DynaLoader);

# Items to export into callers namespace by default.
@EXPORT = qw(
PGRES_CONNECTION_OK
PGRES_CONNECTION_BAD
PGRES_EMPTY_QUERY
PGRES_COMMAND_OK
PGRES_TUPLES_OK
PGRES_COPY_OUT
PGRES_COPY_IN
PGRES_BAD_RESPONSE
PGRES_NONFATAL_ERROR
PGRES_FATAL_ERROR
PGRES_INV_SMGRMASK
PGRES_INV_ARCHIVE
PGRES_INV_WRITE
PGRES_INV_READ
PGRES_InvalidOid
);

$Pg::VERSION = '1.9.0';

---------------------------------------------------------------
The following is the first few lines of the report from make
---------------------------------------------------------------

bash-2.05b$ make
gcc -c -I/usr/lib -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBUGGING -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2
-march=i386 -mcpu=i686 -g -DVERSION=\"1.9.0\" -DXS_VERSION=\"1.9.0\"
-fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE"
Pg.c
Pg.xs:16:22: libpq-fe.h: No such file or directory
Pg.xs:25: parse error before "PGresult"
Pg.xs:25: warning: no semicolon at end of struct or union
Pg.xs:27: parse error before '}' token
Pg.xs:27: warning: data definition has no type or storage class
Pg.xs: In function `XS_Pg_connectdb':