cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Hartmann <andr...@apache.org>
Subject Problem restoring dump with BLOBs
Date Mon, 27 Jul 2009 16:48:12 GMT
Hi everyone,

to import a new version of the schema, I create and restore a dump as 
follows:


pg_dump --data-only --oids --file $dumpfile $db_name
psql -1 […] $db_name < $schemafile
psql -1 […] $db_name < $dumpfile


However, when the dump is restored, I get the following error message:

ERROR:  duplicate key value violates unique constraint 
"pg_largeobject_loid_pn_index"

I tried to clear the pg_largeobject table before restoring the dump, but 
this leads to errors like "PSQLException: ERROR: large object 23313 does 
not exist" when I access the data afterwards.

Thanks a lot for any hints!

-- Andreas

-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01


Mime
View raw message