On Thu, Feb 11, 2010 at 10:08 AM, Bill Moran <wmoran@xxxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
