Re: pg_restore problem

"Jules Alberts" <jules.alberts@arbodienst-limburg.nl> writes:
> This restores the OIDs of all my tables (as I expected), except the
> BLOBs, lo_export(241803, '/tmp/foobar') says "ERROR inv_open large
> object 241803 not found". This is a problem because I save the BLOBs
> OID as a reference in other tables. Am I doing something wrong or is
> this a known issue?

pg_restore should fix up OID references to BLOBs ... if they are in
columns of type OID (or type lo, if you've installed contrib/lo).
I suspect you stored all your OID references in integer columns?

            regards, tom lane