Problems compiling DBD::Pg under IRIX 5.3

Dear all,

In order to get NULLs to be accepted as bind values for '?' in
prepare/execute statements, I have been trying to update my DBI/DBD::Pg set
up from its current status at DBI 1.02 and DBD::Pg 0.79.

Upgrade of DBI was trouble free and I know have DBI 1.13.

I have been unable to upgrade DBD::Pg (failed make outputs are at the end
of this mail)

for information:

perl, version 5.004_04 built for IP22-irix

Summary of my perl5 (5.0 patchlevel 4 subversion 4) configuration:
Platform:
osname=irix, osvers=5, archname=IP22-irix
uname='irix merlin 5.3 11091812 ip22 mips '
hint=recommended, useposix=true, d_sigaction=define
bincompat3=y useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-O', gccversion=
cppflags='-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -DLANGUAGE_C'
ccflags ='-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -Olimit 3000
-DLANGUAGE_C'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
voidflags=15, castflags=1, d_casti32=define, d_castneg=undef
intsize=4, alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /usr/lib /lib
libs=-lmalloc -lsun -lm -lc -lcrypt -lbsd -lPW
libc=/usr/lib/libc.so, so=so
useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-KPIC', lddlflags='-shared -L/usr/local/lib'

Characteristics of this binary (from libperl):
Built under irix
Compiled at Mar 27 1998 17:20:27
@INC:
/usr/local/lib/perl5/IP22-irix/5.00404
/usr/local/lib/perl5
/usr/local/lib/perl5/site_perl/IP22-irix
/usr/local/lib/perl5/site_perl
/usr/local/lib/perl5/IP22-irix

First I tried with DBD::Pg 0.92 and got:

Configuring Pg
Remember to actually read the README file !
$POSTGRES_HOME not defined. Searching for PostgreSQL...
Found PostgreSQL in /usr/local/pgsql
irix
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Pg
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
cp Pg.pm ./blib/lib/DBD/Pg.pm
/usr/local/bin/perl -I/usr/local/lib/perl5/IP22-irix/5.00404
-I/usr/local/lib/perl5 /usr/local/lib/perl5/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/ExtUtils/typemap Pg.xs >Pg.tc && mv Pg.tc Pg.c
cc -c -I/usr/local/pgsql/include -I/usr/local/include/pgsql
-I/usr/include/pgsql -I/usr/local/lib/perl5/site_perl/IP22-irix/auto/DBI
-I/usr/local/lib/perl5/IP22-irix/5.00404/DBI -I/auto/DBI -I/DBI
-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -Olimit 30
cfe: Warning 608: ./Pg.h: 24: Undefined the ANSI standard library defined
macro BUFSIZ (4.1.2.1(9))
cc -c -I/usr/local/pgsql/include -I/usr/local/include/pgsql
-I/usr/include/pgsql -I/usr/local/lib/perl5/site_perl/IP22-irix/auto/DBI
-I/usr/local/lib/perl5/IP22-irix/5.00404/DBI -I/auto/DBI -I/DBI
-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -Olimit 30
cfe: Warning 608: ./Pg.h: 24: Undefined the ANSI standard library defined
macro BUFSIZ (4.1.2.1(9))
cfe: Error: dbdimp.c, line 831: Incompatible pointer type assignment
(3.3.16.1, 3.5.4.1(21))
val = (((phs->sv)->sv_flags & 0x00040000 ) ? (( len =
((XPV*) (phs->sv)->sv_any )->xpv_cur ), ((XPV*) (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len)) ;
-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
cfe: Error: dbdimp.c, line 831: Type int * of this argument is
incompatible with type STRLEN * of function prototype description
(3.3.16.1)
val = (((phs->sv)->sv_flags & 0x00040000 ) ? (( len =
((XPV*) (phs->sv)->sv_any )->xpv_cur ), ((XPV*) (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len)) ;
-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
*** Error code 1 (bu21)
/sbin/make -- NOT OK
Running make test
Oops, make had returned bad status
Running make install
Oops, make had returned bad status

So THEN I read the README (as one does)... and it mentioned that you needed
postgreSQL 6.4.2 onwards for DBD::Pg 0.92... it seemed like a long shot but
I thought perhaps that's what was causing the problem.

So I got hold of DBD::Pg 0.89 (the most up-to-date DBD::Pg compatible with
PG 6.4(.0)) and tried compiling that... again same error message (different
line):

cfe: Error: dbdimp.c, line 826: Incompatible pointer type assignment
(3.3.16.1, 3.5.4.1(21))
val = (((phs->sv)->sv_flags & 0x00040000 ) ? (( len =
((XPV*) (phs->sv)->sv_any )->xpv_cur ), ((XPV*) (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len)) ;
-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
cfe: Error: dbdimp.c, line 826: Type int * of this argument is
incompatible with type STRLEN * of function prototype description
(3.3.16.1)
val = (((phs->sv)->sv_flags & 0x00040000 ) ? (( len =
((XPV*) (phs->sv)->sv_any )->xpv_cur ), ((XPV*) (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len)) ;
-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
*** Error code 1 (bu21)

Any help on getting the compile to work on my box would be greatly
appreciated as would be a cc to stuart(at)ludwig(dot)ucl(dot)ac(dot)uk(dot)

Best regards,

Stuart.

+--------------------------+--------------------------------------+
| Stuart C. G. Rison | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street |
| N.B. new phone code!! | London, W1P 8BT |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM |
| Fax. +44 (0)207 878 4040 | stuart(at)ludwig(dot)ucl(dot)ac(dot)uk |
+--------------------------+--------------------------------------+