cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Hartmann <>
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 

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 

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
Tel.: +41 (0) 43 818 57 01

View raw message