Re: Large Object / libPQ : problem

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chris <linux.fellow@libertysurf.fr>
Cc: pgsql-bugs@postgresql.org
Date: 2000-08-20T02:49:40Z
Lists: pgsql-bugs
Chris <linux.fellow@libertysurf.fr> writes:
> the libpq functions 'lo_open', the function fails. (also, lo_import
> fails in the call to lo_open.) After some experiments, I found that
> the lo_open function seemed to work at open-time, but it's calling
> 'lo_lseek' just after, and that seems not to work.

It sounds like you are neglecting to wrap the whole process in a
transaction block (BEGIN/COMMIT).  The LO handle returned by lo_open
is valid only as long as you keep the current transaction open.

			regards, tom lane