A very timely answer, and we'd debating moving to 9.2 at the same time but decided on staying on the 8.4 line (latest
patchlevel though). After we do this we should be able to do a regular, normal pg_dump (not excluding anything) to get
from8.4 -> 9.2 in a few weeks from now.
Thanks so much Tom.
./scc
On 2012-10-10, at 11:04 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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