Sunday, September 7, 2008

Re: [HACKERS] 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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: