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
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.*' |