Postgres Pro
Downloads
Home   >   mailing lists

problem to restore pg_dump --data-only - Mailing list pgsql-general

From simon litwan
Subject problem to restore pg_dump --data-only
Date
Msg-id 1157016015.5362.112.camel@sibm
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Keith Hutchison"
Date:
Subject: pg_config --includedir is null
Next
From: markus.maryschka@xpluso.com
Date:
Subject: stream data in bytea field + using SSL