Re: Large Object / libPQ : problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris <linux(dot)fellow(at)libertysurf(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Large Object / libPQ : problem
Date: 2000-08-20 02:49:40
Message-ID: 8992.966739780@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Chris <linux(dot)fellow(at)libertysurf(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Unprivileged user 2000-08-21 18:40:43 PostgreSQL BugTool Submission
Previous Message Peter Eisentraut 2000-08-20 00:40:56 Re: Cannot delete newly inserted record while inside a transaction