Re: libpg: large object problems

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: libpg: large object problems
Дата
Msg-id 19956.1052007514@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: libpg: large object problems  (Seth Nickell <snickell@stanford.edu>)
Список pgsql-novice
Seth Nickell <snickell@stanford.edu> writes:
> If I only put one lo_ operation per transaction, I get back "0" for the
> fd (is this a valid fd?). I guess this is an improvement over -1 ;-) It
> seems I can do an lo_write at this point, but lo_read still doesn't let
> me read anything.

I think the lo_open() for reading needs to specify INV_READ.

An error that may or may not be hurting you is that the lo_close in
the write part should specify fd not id.  It is possible that that
mistake is making the writer transaction abort.  The lack of checks
for errors makes it difficult to tell, but you could possibly look
in the postmaster log for clues...

            regards, tom lane


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

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: Re: Error Uninstalling 7.2.2 on Mandrake 9.0
Следующее
От: greg@turnstep.com
Дата:
Сообщение: Re: libpg: large object problems