Received: from mothra.awl.com (reading-ib.awl.com [192.207.117.5])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA86390
	for <pgsql-interfaces@postgresql.org>;
	Fri, 5 Nov 1999 13:56:16 -0500 (EST)
	(envelope-from jason.jones@awl.com)
Received: from jonesj (dhcp-115.stoneham.awl.com [10.8.248.115] (may be
	forged)) by mothra.awl.com (8.9.3/8.9.3) with SMTP id NAA04865
	for <pgsql-interfaces@postgresql.org>;
	Fri, 5 Nov 1999 13:56:36 -0500 (EST)
Message-ID: <008401bf27bf$a93b0f00$73f8080a@awl.com>
From: "Jason Jones" <jason.jones@awl.com>
To: <pgsql-interfaces@postgresql.org>
Subject: help with pygresql and large objects
Date: Fri, 5 Nov 1999 12:57:51 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I'm new to postgresql and using PyGreSQL 2.4 I'm experiencing problems with
large objects. I can create them and destroy them, but can't open them to
read or write. Here is some sample code from the interactive prompt:

>>> import pg
>>> db=pg.connect(blah...)
>>> bigobj = db.locreate(pg.INV_READ|pg.INV_WRITE)
>>> bigobj.oid
18369
>>> bigobj.open(pg.INV_READ|pg.INV_WRITE)
Traceback (innermost last):
  File "<stdin>", line 1, in ?
IOError: can't open large object.
>>> bigobj.error
'ERROR:  lo_lseek: invalid large obj descriptor (0)\012'
>>>

I've tried single constants too, instead of OR'ing them, but nothing seems
to work. I always get the lo_lseek error. I'm probably just doing something
wrong, but I don't know what.

Any ideas?

Thanks,

Jason Jones
jonesj@awl.com