help me please...

okay, i have no idea of a better place to go to for advice so i'm
trying here. if this is the wr ong place to go then i apologize. if
someone wants to help me off-line then that would be great.

i have successfully installed postgresql 7.2 on my OSX box.
everything works just grand with pgsql and dbviusalizer as well. now
i want to get it up and running with perl so that i can port some
existing scripts to use postgres instead of my current database
engine. this is where i'm having some serious difficulties.

i'm trying to build dbd-pg-1.00 on mac osx and am getting compile
errors. i've included information from perl (-v and -V) below as
well as the results from downloading the package and running the
commands directly from the shell as well as running install DBD::Pg
from the cpan module's interactive shell so that you can see where
everything is failing.

i was able to install MD5 and the inet libraries as well as the most
recent cpan modules successfully. this leads me to believe that
there is something specifically wrong with the manner in which i am
attempting to install the postgresql dbd module.

any help is greatly appreciated.

many thanks!

rjsjr

########## perl -v ##########

This is perl, v5.6.0 built for darwin

Copyright 1987-2000, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5.0 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'.  If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

########## perl -V ##########

[localhost:/documents/football/sql] robertsa% perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
  Platform:
    osname=darwin, osvers=1.4, archname=darwin
    uname='darwin law 1.4 darwin kernel version 1.3: sun jul 22 16:20:35 pdt 2001; aramesh:buildobjrelease_ppc power
macintosh powerpc '
    config_args='-ds -e -Dprefix=/usr -Dccflags=-g  -pipe  -Dldflags='
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
    useperlio=undef d_sfio=undef uselargefiles=define
    use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef
  Compiler:
    cc='cc', optimize='-O3', gccversion=Apple devkit-based CPP 6.0
    cppflags='-g -pipe -pipe -fno-common -no-cpp-precomp -flat_namespace -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing'
    ccflags ='-g -pipe -pipe -fno-common -no-cpp-precomp -flat_namespace -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing'
    stdchar='char', d_stdstdio=undef, usevfork=true
    intsize=4, longsize=4, ptrsize=4, doublesize=8
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, usemymalloc=n, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =''
    libpth=/usr/lib
    libs=-lm -lc
    libc=/System/Library/Frameworks/System.framework/System, so=dylib, useshrplib=true, libperl=libperl.dylib
  Dynamic Linking:
    dlsrc=dl_dyld.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' '
    cccdlflags=' ', lddlflags='-bundle  -flat_namespace -undefined suppress'


Characteristics of this binary (from libperl):
  Compile-time options: USE_LARGE_FILES
  Built under darwin
  Compiled at Sep  2 2001 17:24:33
  @INC:
    /System/Library/Perl/darwin
    /System/Library/Perl
    /Library/Perl/darwin
    /Library/Perl
    /Library/Perl
    /Network/Library/Perl/darwin
    /Network/Library/Perl
    /Network/Library/Perl
    .
[localhost:/documents/football/sql] robertsa%


########## building directly ##########

[localhost:dev/perl/dbd-pg-1.00] robertsa% env POSTGRES_INCLUDE=/include/ POSTGRES_LIB=/lib/ perl makefile.pl
Configuring Pg
Remember to actually read the README file !
OS: darwin
Using DBI 1.21 installed in /Library/Perl/darwin/auto/DBI
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lpq
Writing Makefile for DBD::Pg
[localhost:dev/perl/dbd-pg-1.00] robertsa% make
mkdir blib
mkdir blib/lib
mkdir blib/lib/DBD
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBD
mkdir blib/arch/auto/DBD/Pg
mkdir blib/lib/auto
mkdir blib/lib/auto/DBD
mkdir blib/lib/auto/DBD/Pg
mkdir blib/man3
cp Pg.pm blib/lib/DBD/Pg.pm
cp dbd-pg.pod blib/lib/DBD/dbd-pg.pod
/usr/bin/perl -I/System/Library/Perl/darwin -I/System/Library/Perl /System/Library/Perl/ExtUtils/xsubpp  -typemap
/System/Library/Perl/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c
cc -c -I/include/ -I/Library/Perl/darwin/auto/DBI -g -pipe -pipe -fno-common -no-cpp-precomp -flat_namespace
-DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing -O3     -DVERSION=\"1.00\" -DXS_VERSION=\"1.00\"
-I/System/Library/Perl/darwin/CORE  Pg.c
In file included from Pg.xs:13:
Pg.h:17: libpq-fe.h: No such file or directory
In file included from /System/Library/Perl/darwin/CORE/perlsdio.h:5,
                 from /System/Library/Perl/darwin/CORE/iperlsys.h:294,
                 from /System/Library/Perl/darwin/CORE/perl.h:1823,
                 from /Library/Perl/darwin/auto/DBI/DBIXS.h:19,
                 from Pg.h:39,
                 from Pg.xs:13:
/usr/include/stdio.h:204: warning: `BUFSIZ' redefined
Pg.h:34: warning: this is the location of the previous definition
In file included from Pg.h:41,
                 from Pg.xs:13:
dbdimp.h:22: parse error before `PGconn'
dbdimp.h:22: warning: no semicolon at end of struct or union
dbdimp.h:25: parse error before `}'
dbdimp.h:31: parse error before `PGresult'
dbdimp.h:31: warning: no semicolon at end of struct or union
dbdimp.h:44: parse error before `}'
Pg.xs: In function `XS_DBD__Pg__db_commit':
Pg.xs:90: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:90: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__db_rollback':
Pg.xs:101: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:101: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__db_disconnect':
Pg.xs:112: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:112: dereferencing pointer to incomplete type
Pg.xs:116: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:116: dereferencing pointer to incomplete type
Pg.xs:117: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:117: dereferencing pointer to incomplete type
Pg.xs:118: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:118: dereferencing pointer to incomplete type
Pg.xs:122: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:122: dereferencing pointer to incomplete type
Pg.xs:122: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:122: dereferencing pointer to incomplete type
Pg.xs:123: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:123: dereferencing pointer to incomplete type
Pg.xs:125: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:125: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__db_DESTROY':
Pg.xs:165: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:165: dereferencing pointer to incomplete type
Pg.xs:166: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:166: dereferencing pointer to incomplete type
Pg.xs:172: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:172: dereferencing pointer to incomplete type
Pg.xs:173: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:173: dereferencing pointer to incomplete type
Pg.xs:174: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:174: dereferencing pointer to incomplete type
Pg.xs:176: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:176: dereferencing pointer to incomplete type
Pg.xs:177: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:177: dereferencing pointer to incomplete type
Pg.xs:177: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:177: dereferencing pointer to incomplete type
Pg.xs:177: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:177: dereferencing pointer to incomplete type
Pg.xs:179: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:179: dereferencing pointer to incomplete type
Pg.xs:180: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:180: dereferencing pointer to incomplete type
Pg.xs:190: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:190: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__st__prepare':
Pg.xs:356: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:356: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__st_execute':
Pg.xs:447: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:447: dereferencing pointer to incomplete type
Pg.xs:448: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:448: dereferencing pointer to incomplete type
Pg.xs:449: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:449: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__st_finish':
Pg.xs:508: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:508: dereferencing pointer to incomplete type
Pg.xs:509: invalid use of incomplete typedef `imp_dbh_t'
Pg.xs:509: dereferencing pointer to incomplete type
Pg.xs:515: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:515: dereferencing pointer to incomplete type
Pg.xs: In function `XS_DBD__Pg__st_DESTROY':
Pg.xs:576: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:576: dereferencing pointer to incomplete type
Pg.xs:577: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:577: dereferencing pointer to incomplete type
Pg.xs:582: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:582: dereferencing pointer to incomplete type
Pg.xs:583: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:583: dereferencing pointer to incomplete type
Pg.xs:583: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:583: dereferencing pointer to incomplete type
Pg.xs:583: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:583: dereferencing pointer to incomplete type
Pg.xs:585: invalid use of incomplete typedef `imp_sth_t'
Pg.xs:585: dereferencing pointer to incomplete type
Pg.xs: In function `boot_DBD__Pg':
Pg.xs:34: sizeof applied to an incomplete type
Pg.xs:35: sizeof applied to an incomplete type
make: *** [Pg.o] Error 1


########## cpan module install ##########
[localhost:/documents/football/sql] robertsa% sudo env POSTGRESQL_INCLUDE=/include POSTGRESQL_LIB=/lib perl -MCPAN -e
shell; 
Unrecognized escape \C passed through at /Library/Perl/Term/ReadLine/readline.pm line 618.
Unrecognized escape \C passed through at /Library/Perl/Term/ReadLine/readline.pm line 620.

cpan shell -- CPAN exploration and modules installation (v1.59)
ReadLine support enabled

cpan> install DBD::Pg
CPAN: Storable loaded ok
Going to read /Users/robertsa/cache/Metadata
Running install for module DBD::Pg
Running make for M/ME/MERGL/DBD-Pg-1.01.tar.gz
Scanning cache /Users/robertsa/cache/build for sizes
CPAN: MD5 loaded ok
Checksum for /Users/robertsa/cache/sources/authors/id/M/ME/MERGL/DBD-Pg-1.01.tar.gz ok
DBD-Pg-1.01
DBD-Pg-1.01/eg
DBD-Pg-1.01/eg/ApacheDBI.pl
DBD-Pg-1.01/Changes
DBD-Pg-1.01/MANIFEST
DBD-Pg-1.01/Makefile.PL
DBD-Pg-1.01/Pg.h
DBD-Pg-1.01/Pg.pm
DBD-Pg-1.01/Pg.xs
DBD-Pg-1.01/README
DBD-Pg-1.01/README.win32
DBD-Pg-1.01/dbd-pg.pod
DBD-Pg-1.01/dbdimp.c
DBD-Pg-1.01/dbdimp.h
DBD-Pg-1.01/test.pl
Removing previously used /Users/robertsa/cache/build/DBD-Pg-1.01

  CPAN.pm: Going to build M/ME/MERGL/DBD-Pg-1.01.tar.gz

Configuring Pg
Remember to actually read the README file !
please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !
Running make test
  Make had some problems, maybe interrupted? Won't test
Running make install
  Make had some problems, maybe interrupted? Won't install