| From: | simon litwan <simon(dot)litwan(at)wyona(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | problem to restore pg_dump --data-only |
| Date: | 2006-08-31 09:20:15 |
| Message-ID: | 1157016015.5362.112.camel@sibm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | markus.maryschka | 2006-08-31 11:30:48 | stream data in bytea field + using SSL |
| Previous Message | Keith Hutchison | 2006-08-31 04:47:22 | pg_config --includedir is null |