Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

problem to restore pg_dump --data-only



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(dot)litwan(at)wyona(dot)com
Wyona Inc.  -   Open Source Content Management   -   Apache Lenya
http://www.wyona.com                      http://lenya.apache.org




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group