Re: pgsql-server/src/bin/pg_dump pg_backup_archiver.c - Mailing list pgsql-committers

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Tom Lane wrote:
>>
>> Hiroshi Inoue <Inoue@tpf.co.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