Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> Tom Lane wrote:
>>
>> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> Please tell me how we avoid the failure
> ERROR: Unable to identify an operator '=' for types 'oid' and 'lo'
> You will have to retype this query using an explicit cast
> in pg_restore.
>>
>> What query triggers that, exactly?
> The query made by the following code in FixupBlobRefs in pg_backup_db.c.
Hmmm ... does it help if we change the query to
" FROM %s WHERE
%s.oldOid = %s.%s::pg_catalog.oid",
I suspect though that the real issue is the CREATE CAST is failing;
if so, this won't help. See my comment to Peter earlier today.
regards, tom lane