[Gnumed-devel] re: tricky

[Syan Tan]

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; ?