| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | one other thought |
| Date: | 2003-10-10 16:30:11 |
| Message-ID: | 3F86DE93.5070803@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am trying to restore data from a database that did not have any PK and
FK constraints to one that now does. Could this be my issue? I would
have expected to get errors if any constraint violations occured but not
a hanging of the system.
How does the dump order the tables? I reordered my tables in my schema
script such that they satisfied the way the constraints were set up.
Does the dump that I create from my non-constraint database order the
tables in a particular manner that might not be consistent with how they
are now generated in the creation script?
Thanks
Jodi
--
/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>/
/ /
/ /
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jodi Kanter | 2003-10-10 16:50:07 | data restore |
| Previous Message | Jodi Kanter | 2003-10-10 16:25:09 | data restore |