We would also like to see your prepare statement with a little more
description of the fields that are being binded.
Ilya Sterin
-----Original Message-----
From: Rick Cochran
To: [EMAIL PROTECTED]
Sent: 05/02/2001 9:05 AM
Subject: DBD::Pg errstr problem
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]|
