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@virginia.edu