From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | <pgsql-committers(at)postgresql(dot)org> |
Subject: | Re: pgsql-server/src/bin/pg_dump pg_backup_archiver.c |
Date: | 2003-01-10 15:45:29 |
Message-ID: | EKEJJICOHDIEMGPNIFIJGEOHKEAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
> -----Original Message-----
> From: Hiroshi Inoue
>
> Tom Lane wrote:
> >
> > 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.
>
> I know it from the first and the consideration is useless
> unless we use 7.3 pg_dump.
If there's no objection, I would apply the fix to 7.3-STABLE tree.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-10 19:40:11 | Re: pgsql-server/src/bin/pg_dump pg_backup_archiver.c |
Previous Message | Peter Eisentraut - PostgreSQL | 2003-01-10 11:02:52 | pgsql-server/ oc/src/sgml/features.sgml oc/src ... |