Re: question about pg_dump -a - Mailing list pgsql-general

From Ottavio Campana
Subject Re: question about pg_dump -a
Date
Msg-id 46FD5847.9020809@campana.vi.it
Whole thread Raw
In response to Re: question about pg_dump -a  (Vivek Khera <vivek@khera.org>)
List 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?


Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Using RETURNING with INTO inside pgsql
Next
From: Mike Charnoky
Date:
Subject: Re: more problems with count(*) on large table