Ron Snyder <snyder(at)roguewave(dot)com> writes:
> The field (in table "attachments") that references the loid (in
> pg_largeobject) is storing the loid as text-- is that possibly what's making
> it difficult for us to do this upgrade?
Yup. pg_dump/pg_restore know about updating LO references that are
stored as OIDs or as type "lo" (see contrib/lo and friends). They
have no reason to think that those digit strings in your text column
have anything to do with your large objects.
regards, tom lane