Re: Another LargeObject problem

Ole Streicher <ole-usenet-spam@xxxxxxx> writes:
> I have another Problem when using LargeObjects.
>> From time to time, I get the exception
> FastPath call returned ERROR:  lo_lseek: invalid large obj descriptor (369)
> What does this exception mean?

It means the descriptor you opened with lo_open isn't open anymore (or
that you're passing the wrong descriptor number, but the former is more
likely).  Descriptors are closed at transaction end, so you have to hold
open a transaction block for your entire lo_open .. lo_close sequence.

> It occurs randomly; a repeated retrieval works usually.

If it seems "random" then you are probably being careless with
connection pooling.  You've got to hold onto the same connection and
same transaction for as long as you're using the LO.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx