Re: Large object - what's happening?

From: Warwick Hunter <whunter(at)agile(dot)tv>
To: Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Large object - what's happening?
Date: 2003-08-14 23:19:45
Message-ID: 1060903185.4431.14.camel@stradbroke.oz.agile.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)agile(dot)tv http://www.agile.tv

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Girish Bajaj 2003-08-14 23:39:17 Qualified Names
Previous Message Tom Lane 2003-08-14 18:01:07 Re: User/login questions