Large Object Problem with Python interface

From: Lauri Posti <lauri(at)peak(dot)edu(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Large Object Problem with Python interface
Date: 1999-06-15 16:16:59
Message-ID: Pine.LNX.3.96.990615161114.32694A-100000@vi.eenet.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)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(at)\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)

Browse pgsql-general by date

  From Date Subject
Next Message Collin F. Lynch 1999-06-15 18:02:17 pgsql-announce@postgresql.org, pgsql-admin@postgresql.org, pgsql-docs@postgresql.org
Previous Message Arendt, Volker 1999-06-15 14:32:02 subscribe pgsql-general