Thread: problem to restore pg_dump --data-only

problem to restore pg_dump --data-only

From
simon litwan
Date:
hello all

i've did pg_dump --data-only for quit a while and didn't have any
problem with restoring the resulting backup.

but since the schema changed slightly the restore fails:
ERROR: insert or update in table "angebotsmuster" violates
foreignkey-constraints

it seems to me like the order of the inserts is not ok.

is there any solution for this problem?

any hint is appreciated.

simon



--
Simon Litwan                               simon.litwan@wyona.com
Wyona Inc.  -   Open Source Content Management   -   Apache Lenya
http://www.wyona.com                      http://lenya.apache.org