Re: Proposed patch: make pg_dump --data-only consider FK constraints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposed patch: make pg_dump --data-only consider FK constraints
Date
Msg-id 21004.1220815043@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposed patch: make pg_dump --data-only consider FK constraints  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Heikki Linnakangas wrote:
>> How about printing that notice at the top of the dump file as well?

> I assume that this trick will only work at restore time only for custom
> or tar dumps.  A text-only dump would produce the warning to stderr at
> dump time, no?

Yes, the warning (and the re-sorting) must happen at dump time.  Given a
data-only dump, pg_restore wouldn't even have the information needed to
do anything about this.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed patch: make pg_dump --data-only consider FK constraints
Next
From: Martin Pihlak
Date:
Subject: Re: reducing statistics write overhead