Hi,
i have a problem updating to v7.2.3 -> v7.3. i have a lot of BLOBs i want to take along. problem boils down to this:
althoughthere is FixupBlobRefs-code in pg_backup_db.c to "fix" the references to the BLOBs ( because of the
non-avoidableoid change ), is does not work for me because the database is not able to compare lo with anything, i
can'teven compare lo with a lo. i have fooled around in the FixupBlobRefs code to do some typecasting, but to no avail.
problem is, i can not add such operator before i do the pg_restore because then, during restore, it will complain that
lo-typealready exists. in 7.2.3 i patched the pg_restore code to continue, even if there were errors. and i needed this
ondifferent occasions. would it be possible to include an "ignore-errors" flag to pg_restore?
i suspect this problem is due to the new "operator" class?
regards,
Jan Branbergen
Evation.com
* Version 7.3
* OS: FreeBSD 4.7
* Steps:
1. install pg7.2.3, run contrib/lo
2. import some blobs
3. do a pg_dump -Fc etc to get the blobs into the dump
4. upgrade to pg7.3
5. do a pg_restore -Fc etc to import it.
6. note the errors about the BLOB-xref-updates