Re: reading reading files from the DB

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: reading reading files from the DB
Дата
Msg-id 20051229074442.GA46583@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: reading reading files from the DB  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-admin
On Wed, Dec 28, 2005 at 09:47:34PM -0700, Michael Fuhr wrote:
> What are you expecting to happen and what actually does happen?

Another thing: are you calling the lo_* functions within a transaction?
As the Client Interfaces section of the Large Objects chapter in
the documentation says, "All large object manipulation using these
functions must take place within an SQL transaction block."  If you
call lo_open() outside a transaction block then it will fail and
PQerrorMessage() will return a string like "invalid large-object
descriptor: 0".

--
Michael Fuhr

В списке pgsql-admin по дате отправления:

Предыдущее
От: Gourish Singbal
Дата:
Сообщение: Re: migrating oracle table to PostgresQL
Следующее
От: Mohamed Fazil
Дата:
Сообщение: Req Documentation for installing PG SQL8.1 by hand