Re: Large Objects and Replication question

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Large Objects and Replication question
Дата
Msg-id 20091203.093640.129788615.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: Large Objects and Replication question  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-general
> >  However you need to use newer API
> > of libpq to create large objects:
> >
> > Oid lo_create(PGconn *conn, Oid lobjId);
> [...]
> > You cannot use old API lo_creat() since it relies on OID, which
> > pgpool-II does not guarantee OIDs can be replicated.
>
> Does it mean that lo_create(conn, 0) is supported while
> lo_creat(conn,INV_READ|INV_WRITE) is not ?
> It sounds strange from the user's point of view, because they do the same
> thing, don't they?

Well, I do not recommend to use lo_create(conn, 0) either.

Actually users can use lo_create(conn, 0) or lo_create without any
problem until you try to extract existing large objects by oid.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: using querys like: 'select table.*'
Следующее
От: Bill Todd
Дата:
Сообщение: Re: quote string exactly as it is