jboes(at)nexcerpt(dot)com (Jeff Boes) writes:
> I've turned off every trigger in the database:
> update pg_triggers set tgenabled=false;
AFAIR, tgenabled isn't really supported; it's not tested for AFTER
triggers, which is what foreign keys use. Your debug trace certainly
shows that the FK triggers are still live.
pg_dump knows how to disable triggers for real; I think it involves
setting pg_class.reltriggers to zero.
regards, tom lane