Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 Sep 2007 21:38:47 +0200
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:
signature.asc
Description: OpenPGP digital signature
- References:
- question about pg_dump -a
- From: Ottavio Campana
- Re: question about pg_dump -a
- From: Richard Huxton
- Re: question about pg_dump -a
- From: Ottavio Campana
- Re: question about pg_dump -a
- From: Vivek Khera
- question about pg_dump -a
- Prev by Date: Re: Using RETURNING with INTO inside pgsql
- Next by Date: Re: more problems with count(*) on large table
- Previous by thread: Re: question about pg_dump -a
- Next by thread: usage of indexes for inner joins
- Indexes: