Eric Marsden <emarsden@mail.dotcom.fr> writes:
> lo_open returns 0 as a file descriptor. However, following up with one
> of the other lo functions which take descriptor arguments (such as
> lo_write or lo_tell) fails with
> ERROR: lo_tell: invalid large object descriptor (0)
Are you remembering to wrap this sequence in a transaction block
(begin/end)? LO descriptors are only valid till end of transaction.
regards, tom lane