"Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)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
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-08-15 13:27:02|
|Subject: Re: FATAL 1:Sorry, too many clients |
|Previous:||From: sol||Date: 2002-08-15 11:45:31|
|Subject: FATAL 1:Sorry, too many clients|