Hosting Provided By

Re: [GENERAL] question about pg_dump -a

From: Ottavio Campana <ottavio(at)campana.vi.it>
Date: Fri Sep 28 2007 - 15:38:47 EDT

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?

application/pgp-signature attachment: OpenPGP digital signature

Received on Fri Sep 28 15:41:57 2007

This message: [ Message body ]
Next message: Mike Charnoky: "Re: [GENERAL] more problems with count(*) on large table"
Previous message: Bruce Momjian: "Re: [GENERAL] Using RETURNING with INTO inside pgsql"
In reply to: Vivek Khera: "Re: [GENERAL] question about pg_dump -a"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 11:57:47 EDT