Re: pg_restore problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jules(dot)alberts(at)arbodienst-limburg(dot)nl
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_restore problem
Date: 2002-08-15 13:22:41
Message-ID: 22387.1029417761@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-08-15 13:27:02 Re: FATAL 1:Sorry, too many clients
Previous Message sol 2002-08-15 11:45:31 FATAL 1:Sorry, too many clients