Re: restoring databases with intensive foreign key use

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: restoring databases with intensive foreign key use
Дата
Msg-id 20020514084856.D27828-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на restoring databases with intensive foreign key use fails  (Tino Wildenhain <tino@wildenhain.de>)
Список pgsql-general
On Wed, 8 May 2002, Tino Wildenhain wrote:

> Hi,
>
> restoring the database only from pg_dump/pg_restore
> seems to be impossible if one uses foreign keys much.
> The tables referenced are most of the time not available
> by the time the referencing tables are created. Even
> restoring by OID order does not help.

I haven't used any of the custom dump formats, but the text
one should put the constraint information at the bottom after
table and data creation as create constraint trigger statements.
What does your dump look like?



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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: transitioning postgres oid
Следующее
От: tony
Дата:
Сообщение: Re: Using COPY