Re: problem with fe/be protocol and large objects - Mailing list pgsql-hackers

From Tom Lane
Subject Re: problem with fe/be protocol and large objects
Date
Msg-id 19497.984498747@sss.pgh.pa.us
Whole thread Raw
In response to problem with fe/be protocol and large objects  (Eric Marsden <emarsden@mail.dotcom.fr>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Do we still need PowerPC-specific timestamp_is_current/epoch?
Next
From: Bruce Momjian
Date:
Subject: Re: Performance monitor