Sunday, September 7, 2008

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

Alvaro Herrera <> 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

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

No comments: