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@xxxxxxxxx Wyona Inc. - Open Source Content Management - Apache Lenya http://www.wyona.com http://lenya.apache.org