On Thu, Feb 11, 2010 at 10:08 AM, Bill Moran <wmoran@potentialtech.com> wrote:
>
> If I do:
> pg_dump -a --disable-triggers
>
> I get a warning message:
> pg_dump: NOTICE: there are circular foreign-key constraints among these table(s):
> pg_dump: directory
> pg_dump: You may not be able to restore the dump without using --disable-triggers or temporarily dropping the
constraints.
> pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.
>
> Of course, this was confusing as hell -- we spent a good bit of time
> trying to figure out why pg_dump wasn't honoring --disable-triggers.
>
> It turns out that it is, it's just that it prints the warning even
> when it's not applicable.
But it's not a warning, it's a NOTICE.
