Re: question about pg_dump -a

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: question about pg_dump -a
Дата
Msg-id 8F8AB379-0E8A-406F-B023-63B28FA0AD3C@khera.org
обсуждение исходный текст
Ответ на Re: question about pg_dump -a  (Ottavio Campana <ottavio@campana.vi.it>)
Ответы Re: question about pg_dump -a  (Ottavio Campana <ottavio@campana.vi.it>)
Список pgsql-general
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.

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Debian problem...
Следующее
От: "John D. Burger"
Дата:
Сообщение: Re: access privileges: grant select on (all current and future tables)?