[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] question about pg_dump -a
From:       Ottavio Campana <ottavio () campana ! vi ! it>
Date:       2007-09-28 19:38:47
Message-ID: 46FD5847.9020809 () campana ! vi ! it
[Download RAW message or body]


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?


["signature.asc" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]