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

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
> >> That's one reason that I didn't like solving it by hacking pg_dump.
>
> > My fix works well with the scenario 7.2 pg_restore -> 7.3 pg_restore.
> > It's another problem that 7.3 pg_dump -> 7.3 pg_restore fails.
>
> Perhaps we're talking at cross-purposes. Exactly what was the failure
> that your fix was intended to prevent?

I've already mentioned it.
If you use 7.2 pg_dump to backup 7.2 db and use 7.3 pg_restore to
reload the data, you would see the failure
ERROR: Unable to identify an operator '=' for types 'oid' and 'lo'
You will have to retype this query using an explicit cast
7.3 pg_restore doesn't generate *CREATE CAST* commands
at all for 7.2 or earlier pg_dump data.
Usually people uses 7.2 pg_dump not 7.3 pg_dump to backup 7.2 db.

regards,
Hiroshi inoue