From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql-server/src/bin/pg_dump pg_backup_archiver.c |
Date: | 2003-01-06 09:14:32 |
Message-ID: | 3E1948F8.B5FC996@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut - PostgreSQL | 2003-01-06 09:58:37 | pgsql-server/src backend/libpq/auth.c backend/ ... |
Previous Message | Tom Lane | 2003-01-06 06:25:53 | Re: pgsql-server/src/bin/pg_dump pg_backup_archiver.c |