Large object - what's happening?

From: Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Large object - what's happening?
Date: 2003-08-14 04:59:53
Message-ID: 2483EF5A-CE14-11D7-95C2-00039390F614@anu.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I decided how to deal with my large objects, and now I'm trying to get
them going in a python script.

I'm using pygresql. Is this considered a good thing? Should I use
something else? The syntax looks so simple - just loimport(filename)

I get a python error:
_pg.err: can't create large object

In the postmaster log is a one-liner:
ERROR: lo_lseek: invalid large obj descriptor (0)

Maybe I'm calling it wrong. Maybe I need to upgrade from 7.2.1 to
7.3.x? Maybe I need a new book - Practical Postgresql is very light on
discussion of large objects, and is based on 7.1 or so.

Any clues? Pointers to documents?

thanks
Cath
Cath Lawrence, Cath(dot)Lawrence(at)anu(dot)edu(dot)au
Senior Scientific Programmer, Centre for Bioinformation Science,
John Curtin School of Medical Research (room 4088)
Australian National University, Canberra ACT 0200
ph: (02) 61257959 mobile: 0421-902694 fax: (02) 61252595

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thiemo Kellner 2003-08-14 05:20:31 Re: How can I index a substring attribute?
Previous Message Stephan Szabo 2003-08-14 02:23:58 Re: drop/add fk in transaction