Possible Bug - Mailing list 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@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
'$@="\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";`$@`'