SQL-Dump and refertial Integrity

Поиск
Список
Период
Сортировка
От Thomas Woehlke
Тема SQL-Dump and refertial Integrity
Дата
Msg-id 3CBAD196.B64848F0@ESC-Electronics.de
обсуждение исходный текст
Ответ на Re: Synchronizing databases  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: SQL-Dump and refertial Integrity  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: SQL-Dump and refertial Integrity  ("Joshua b. Jore" <josh@greentechnologist.org>)
Список pgsql-novice
Hi @All!

I have a problem on dumping a database:

If I export the Structure via pg_dump
the table are dumped in alphabetical order, but the order violates
the refenrential integrity of my db.

At inserting it via psql db < db_structure.sql it throws errors and the
database is not not correctly build on the other server. Tables are
missing.

Are there any known solutions or a workaround?

I would greatly appreciate receiving an helping answer even if this
question is very newbie-like.

Thank You

Thomas

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bartus Levente
Дата:
Сообщение: writing to file
Следующее
От: "cristi"
Дата:
Сообщение: Date format