Karsten Wrote:
When replaying this dump file into a database we cannot guarantee that the original primary keys are still unused. However, primary keys are not supposed to carry business meaning. Hence the dump file may be constructed in such a way that first a new row is created in the "root" table (eg identity) and the new "root" primary key is gotten from that and used in the process to write appropriate dependant insert queries. Likewise with further keyed dependancies ... Oh, and: - Preferably client_encoding unicode should be used to cleanly get across all text data. - The dump file should be runnable inside a transaction. can one use begin; set constraints off; .... set constraints on; commit; ? _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
