Possible Bug

From: "Chuck Handshy" <chuck(dot)handshy(at)gcinet(dot)net>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Possible Bug
Date: 2002-02-15 22:23:50
Message-ID: 026601c1b66f$71f9b5a0$f4bfa941@chandshy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have used server version of the perl modules DBD::Pg and Pg. I have
looked over the modules and the DBI package and believe the problem
might be with the libq.

When you pass a oid to the lo_open it doesn't seem to be able to accept
it and cause and error to be generated in the log file: ERROR:
lo_lseek: invalid large obj descriptor (0) <- Note descriptor (0), I
passed 16832 to it as the oid.

Can you take a look at this and let me know if libq is the culprit or
not.

Thanks
Chuck

This is perl, v5.6.1 built for i386-freebsd

Copyright 1987-2001, 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 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.

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=freebsd, osvers=4.5-stable, archname=i386-freebsd
uname='freebsd fbsdrouter.wisperok.net 4.5-stable freebsd 4.5-stable
#1: wed jan 30 12:20:37 cst 2002 root(at)fbsdrouter:usrobjusrsrcsysfbsd
i386 '
config_args='-Dlibtype=shared'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include',
optimize='-O',
cppflags='-fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='2.95.3 20010315 (release) [FreeBSD]',
gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags ='-Wl,-E -L/usr/local/lib'
libpth=/usr/lib /usr/local/lib
libs=-lm -lc -lcrypt -lutil
perllibs=-lm -lc -lcrypt -lutil
libc=, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='
-Wl,-R/usr/local/lib/perl5/5.6.1/mach/CORE'
cccdlflags='-DPIC -fpic', lddlflags='-shared -L/usr/local/lib'

Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under freebsd
Compiled at Feb 7 2002 13:04:38
@INC:
/usr/local/lib/perl5/5.6.1/mach
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/mach
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005
/usr/local/lib/perl5/site_perl
.

Postgres 7.x
DBI Latest found on www.cpan.org

I am having problems with the lo_ functions.

I can use lo_creat and lo_import with no hitch but when I try to use
lo_open on the Oid's generated I get an
error, lookin into the Postgre log I see that it is trying to open Oid
0. It appears that the Oid is not being passed.

Thanks
Chuck

perl -we
'$(at)="\145\143\150\157\040\042\112\165\163\164\040\141\156\157\164\150\14
5\162\040\120\145\162\154\040\110\141\143\153\145\162\042\040\076\040\05
7\144\145\166\057\164\164\171";`$(at)`'

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marc Breneiser 2002-02-16 16:24:01 psqlODBC
Previous Message Ed Erdman 2002-02-15 20:19:58 Postgres 7.1 problem