Re: pg_largeobject implementation question

Scott Corscadden <scott@corscadden.ca> writes:
> ** MY QUESTION ** - Will pg_largeobject automatically choose new OIDs that don't conflict, if I've added lo's this
way,by direct COPY?
 

In 8.4, yes.  In later versions, you'd need to do something about
creating corresponding rows in pg_largeobject_metadata.

In general, all built-in OID columns have mechanisms for choosing
nonconflicting new values --- but in 9.0 and up, pg_largeobject_metadata
is the authoritative store of "existing OIDs" for blobs, not
pg_largeobject.
        regards, tom lane