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
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 |