Large Object Problem with Python interface - Mailing list pgsql-general

From Lauri Posti
Subject Large Object Problem with Python interface
Date
Msg-id Pine.LNX.3.96.990615161114.32694A-100000@vi.eenet.ee
Whole thread Raw
List pgsql-general
Hi.

Im trying to access prostrgeres (on redhat linux 6.0) via pg's LO python
interface.
With pg 6.4.2 & 6.5b1 everything works fine, but since  6.5b2 (6.5 final
incl) following errors occour:


[lauri@liha lauri]$ python
Python 1.5.2 (#2, Jun 12 1999, 02:51:28)  [GCC egcs-2.91.66
19990314/Linux (egcs- on linux2
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> from pg import *
>>> con=connect("kaladb","",5432,"","","koll","koll")
>>> a=con.locreate(INV_WRITE)
>>> a.open(INV_WRITE)
Traceback (innermost last):
  File "<stdin>", line 1, in ?
IOError: can't open large object.
>>>

and postmaster produces following output:

[postgres@liha pgsql]$ postmaster -i -d 3
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
binding ShmemCreate(key=52e2c1, size=1063936)

/usr/local/pgsql/bin/postmaster: ServerLoop:            handling reading
5
/usr/local/pgsql/bin/postmaster: ServerLoop:            handling reading
5
/usr/local/pgsql/bin/postmaster: ServerLoop:            handling writing
5
/usr/local/pgsql/bin/postmaster: BackendStartup: environ dump:
-----------------------------------------
        USERNAME=
        HISTSIZE=1000
        HOSTNAME=liha.linnet.lan
        LOGNAME=postgres
        HISTFILESIZE=1000
        MAIL=/var/spool/mail/postgres
        TERM=vt100
        HOSTTYPE=i386

PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/pgsql/bin:/usr/local/pgsql/bin

        HOME=/usr/local/pgsql
        INPUTRC=/etc/inputrc
        SHELL=/bin/bash
        PS1=[\u@\h \W]\$
        USER=postgres
        PGDATA=/local/var/pgsql/
        BASH_ENV=/usr/local/pgsql/.bashrc
        OSTYPE=Linux
        SHLVL=1
        _=/usr/local/pgsql/bin/postmaster
        POSTPORT=5432
        POSTID=2147483647
        PG_USER=allah
        IPC_KEY=5432000
-----------------------------------------
/usr/local/pgsql/bin/postmaster child[11382]: starting with
(/usr/local/pgsql/bin/postmaster: BackendStartup: pid 11382 user allah
db kaladb socket 5
/usr/local/pgsql/bin/postgres -d3 -v131072 -p kaladb )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
        User         = allah
        RemoteHost   = localhost
        RemotePort   = 0
        DatabaseName = kaladb
        Verbose      = 3
        Noversion    = f
        timings      = f
        dates        = Normal
        bufsize      = 64
        sortmem      = 512
        query echo   = f
InitPostgres
StartTransactionCommand
query: select proname, oid from pg_proc where proname = 'lo_open' or
proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink' or
proname = 'lo_lseek' or proname = 'lo_tell' or proname = 'loread' or
proname = 'lowrite'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
CommitTransactionCommand
StartTransactionCommand
CommitTransactionCommand
StartTransactionCommand
ERROR:  lo_lseek: invalid large obj descriptor (0)
AbortCurrentTransaction
pmdie 2
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)






pgsql-general by date:

Previous
From: Steffen Zimmert
Date:
Subject: Installation problems with v6.5
Next
From: "Collin F. Lynch"
Date:
Subject: pgsql-announce@postgresql.org, pgsql-admin@postgresql.org, pgsql-docs@postgresql.org