upgrade to v7.3 and BLOBs
От | jan@evation.com |
---|---|
Тема | upgrade to v7.3 and BLOBs |
Дата | |
Msg-id | 20021210155231.ORHH13007.amsfep13-int.chello.nl@jan.man обсуждение исходный текст |
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: