The following code:
$insert_fundsource->execute("$aalias -
tmp[1]",$tmp[1],$aalias,$tmp[4],$accttypes{$tmp[2]},$tmp[5])
or carp "Unable to insert fundsource (".$dbh->errstr.")\n";
produces the following error messages:
DBD::Pg::st execute failed: ERRO at init_accounts line 163.
Unable to insert fundsource (ERRO)
DBD::Pg::st execute failed: at init_accounts line 163.
Unable to insert fundsource (7)
Any help would be greatly appreciated!!
-Rick
Here's all the twisty little configuration details:
Platform: AIX 4.2.3
Perl (and therefore DBD::Pg) is compiled with xlc.
PostgreSQL is compiled with gcc.
curdie> perl -v
This is perl, v5.6.0 built for aix
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.
curdie> perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=aix, osvers=4.3.2.0, archname=aix
uname='aix mqh 3 4 002071074200 '
config_args='-Dprefix=/usr/common -des'
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='-O', gccversion=
cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384'
ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -q32 -D_LARGE_FILES -qlonglong'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
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='ld', ldflags =' -b32'
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lbind -lnsl -ldbm -ldl -lld -lm -lC -lc -lcrypt -lbsd -lPW -liconv
libc=/lib/libc.a, so=a, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef,
ccdlflags=' -bE:/usr/common/lib/perl5/5.6.0/aix/CORE/perl.exp'
cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp
-bE:$(BASEEXT).exp -b noentry -lC -lc'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under aix
Compiled at Apr 11 2000 14:43:13
@INC:
/usr/common/lib/perl5/5.6.0/aix
/usr/common/lib/perl5/5.6.0
/usr/common/lib/perl5/site_perl/5.6.0/aix
/usr/common/lib/perl5/site_perl/5.6.0
/usr/common/lib/perl5/site_perl
.
PostgreSQL version 7.1
DBD-Pg version 0.98
DBI version 1.13
|Rick Cochran phone: 607-255-7618|
|Network and Computing Systems, Cornell CIT FAX: 607-255-8521|
|730 Rhodes Hall, Ithaca, N.Y. 14853 email: [EMAIL PROTECTED]|