Re: Large Object / libPQ : problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Large Object / libPQ : problem
Дата
Msg-id 8992.966739780@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Large Object / libPQ : problem  (Chris <linux.fellow@libertysurf.fr>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Cannot delete newly inserted record while inside a transaction
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: PostgreSQL BugTool Submission