On Sunday 21 February 2010 10:38:18 am Dennis Gearon wrote: > Version 8.4 on Ubuntu Linux (is this still supported?) It is the most current stable version, so yes it is supported. > > I'm getting an error upon inserting a copy version of a database dump. It's > very simple, 4 tables, > > TableA 2 records (basically a lookup table) > TableB 15 records > TableC 46 records ( many side of 'one to many') > TableD 55 records.( one side of 'one to many') > > Each table has a sequence, one has an index. > > TableC has a Foreign key to TableD (child/parent respectively) > TableD has a Foreign Key to TableA (child/parent respectively) > > The problem I get is that inserting the copy into a blank database gives me > errors when it gets to TableD because 2nd record in TableA seems not to be > available to reference for the foreign key in TableD. It doesn't even > matter if I rearrange the database dump contents to insert all the parents > first, it always fails there. A couple of questions. 1) Are you dumping/restoring from the same version to same version? 2) What do your dump command and restore commands look like? > > However, if I split the file up, and do one table at a time, it works just > fine. Is this a known issue, feature, or I am doing something wrong? I > thought that doing a database recovery using a copy version of a dump would > be a no brainer, it would happen all in one transaction? I am not sure what you mean by a copy version? > > > Dennis Gearon > -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
