Re: Large object - what's happening? - Mailing list pgsql-novice

From Warwick Hunter
Subject Re: Large object - what's happening?
Date
Msg-id 1060903185.4431.14.camel@stradbroke.oz.agile.tv
Whole thread Raw
In response to Large object - what's happening?  (Cath Lawrence <Cath.Lawrence@anu.edu.au>)
Responses Re: Large object - what's happening?
List pgsql-novice
Cath

> 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)

Make sure that you are doing the large object manipulation
inside a transaction. I saw this type of error from the
C interface when I forgot to wrap it in a transaction.

It could also be caused by permissions. I think your
database user needs some special priveleges to be able
to create large objects.

Warwick
--
Warwick Hunter                    Agile TV Corporation
Voice: +61 7 5584 5912            Fax: +61 7 5575 9550
mailto:whunter@agile.tv           http://www.agile.tv


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: User/login questions
Next
From: "Girish Bajaj"
Date:
Subject: Qualified Names