pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
help with pygresql and large objects
3+ messages / 1 participants
[nested] [flat]

* help with pygresql and large objects
@ 1999-11-05 18:57  Jason Jones <jason.jones@awl.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jason Jones @ 1999-11-05 18:57 UTC (permalink / raw)
  To: pgsql-interfaces

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* help with PyGreSQL and large objects
@ 1999-11-05 20:50  Jason Jones <jason.jones@awl.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jason Jones @ 1999-11-05 20:50 UTC (permalink / raw)
  To: pgsql-interfaces

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* help with PyGreSQL and large objects
@ 1999-11-06 21:16  Jason Jones <jason.jones@awl.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jason Jones @ 1999-11-06 21:16 UTC (permalink / raw)
  To: pgsql-interfaces

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







^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-11-06 21:16 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-05 18:57 help with pygresql and large objects Jason Jones <jason.jones@awl.com>
1999-11-05 20:50 help with PyGreSQL and large objects Jason Jones <jason.jones@awl.com>
1999-11-06 21:16 help with PyGreSQL and large objects Jason Jones <jason.jones@awl.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox