Re: question about pg_dump -a

Поиск
Список
Период
Сортировка
От Ottavio Campana
Тема Re: question about pg_dump -a
Дата
Msg-id 46FD5847.9020809@campana.vi.it
обсуждение исходный текст
Ответ на Re: question about pg_dump -a  (Vivek Khera <vivek@khera.org>)
Список pgsql-general
Vivek Khera ha scritto:
>
> On Sep 28, 2007, at 9:07 AM, Ottavio Campana wrote:
>
>> But why does pg_dump does not already exports data such that previous
>> tables do not depend on successive ones?
>
> Because you can't always sort your tables that way.  The restore
> procedure is responsible for either sorting or disabling the FK checks
> during bulk load.  The latter is more efficient, especially if there are
> no indexes yet, as in a full restore from dump.

how can FK checks be disabled? is there a command?


Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Using RETURNING with INTO inside pgsql
Следующее
От: Mike Charnoky
Дата:
Сообщение: Re: more problems with count(*) on large table