Re: Large Object / libPQ : problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Large Object / libPQ : problem
Date
Msg-id 8992.966739780@sss.pgh.pa.us
Whole thread Raw
In response to Large Object / libPQ : problem  (Chris <linux.fellow@libertysurf.fr>)
List 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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Cannot delete newly inserted record while inside a transaction
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: PostgreSQL BugTool Submission