Re: pg_restore and FK constraints with large dbs

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: pg_restore and FK constraints with large dbs
Дата
Msg-id Pine.LNX.4.44.0311161619270.5327-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: pg_restore and FK constraints with large dbs  (ow <oneway_111@yahoo.com>)
Ответы Re: pg_restore and FK constraints with large dbs
Список pgsql-admin
ow writes:

> --- Peter Eisentraut <peter_e@gmx.net> wrote:
> > If you you pg_dump and dump schema and data together, then there is some
> > magic to temporarily disable foreign key constraints.  Try it out.
>
> Dunno. Don't see any magic so far. In fact, pg_restore appears to use
> internally the same SQL to verify that the validity of the FKs as "ALTER TABLE
> xxx ADD CONSTRAINT". And it's not any faster either.

Read again.  No one was talking of pg_restore.

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: Yuji Shinozaki
Дата:
Сообщение: Re: compare two databases
Следующее
От: ow
Дата:
Сообщение: Re: pg_restore and FK constraints with large dbs