Re: problem with fe/be protocol and large objects
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Eric Marsden <emarsden@mail.dotcom.fr>
Cc: pgsql-hackers@postgresql.org
Date: 2001-03-13T15:52:27Z
Lists: 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