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: although there is FixupBlobRefs-code in
pg_backup_db.c to "fix" the references to the BLOBs ( because of the non-avoidable oid
change ), is does not work for me because the database is not able to compare lo with
anything, i can't even 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-type already exists. in 7.2.3 i patched the
pg_restore code to continue, even if there were errors. and i needed this on different
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
