Re: Proposed patch: make pg_dump --data-only consider FK constraints

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