If, for example, table a has a constraint that references rows in table b, table b has to be restored first, but pg_dump doesn't take that into account. So the restore tries to restore table a first, but can't because table b contains no data. That's what I ran into in general terms.
It is illegal to write a check constraint that references another table. It doesn't matter that hiding your illegal setup inside a back box function prevents the system from stopping you. You need to fix your design so as not to break the documented rules. Namely by using a trigger.
