Re: question about pg_dump -a

From: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
To: Vivek Khera <vivek(at)khera(dot)org>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: question about pg_dump -a
Date: 2007-09-28 19:38:47
Message-ID: 46FD5847.9020809@campana.vi.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Charnoky 2007-09-28 20:23:11 Re: more problems with count(*) on large table
Previous Message Bruce Momjian 2007-09-28 18:56:36 Re: Using RETURNING with INTO inside pgsql