upgrade to v7.3 and BLOBs

From: jan(at)evation(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: upgrade to v7.3 and BLOBs
Date: 2002-12-10 16:39:00
Message-ID: 20021210155231.ORHH13007.amsfep13-int.chello.nl@jan.man
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Brian Walker 2002-12-10 16:47:16 Problem with foreign keys (performance and deadlocks)
Previous Message Tom Lane 2002-12-10 15:27:55 Re: Bug #843: pg_clog files problem