Re: Large Objects and Replication question

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: daniel(at)manitou-mail(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large Objects and Replication question
Date: 2009-12-03 00:36:40
Message-ID: 20091203.093640.129788615.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Todd 2009-12-03 01:37:11 Re: quote string exactly as it is
Previous Message Adrian Klaver 2009-12-03 00:29:49 Re: using querys like: 'select table.*'