Peter Billen wrote: > Hi all, > > I have a problem with foreign keys and data-only (no schema) backup. I > have a simple table node (pseudo-SQL): > When I do a data-only backup, the backup file contains following two lines: > > INSERT INTO NODE (node_id, parent_node_id) VALUES (2, 1); > INSERT INTO NODE (node_id, parent_node_id) VALUES (1, NULL); > > Restoring the backup file into another database ofcourse fails, because > the parent_node_id (1) in the first INSERT statement refers to an > unknown (to be added) node (in the second statement). > > How do I make sure my backup orders the insert statements in a logical > order? You don't. You might find --disable-triggers useful though. See the pg_restore documentation for details. -- Richard Huxton Archonet Ltd
