Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order

It is most likely you have broken some kind of rule in your database schema, but without seeing the dump file it is impossible to point out what you have done wrong.

Relatedly, the bodies of functions are black-boxes, it is not possible to establish dependencies between them.  This limitation is why many of the rules I allude to above exist.

You have also not mentioned what version you are working with.

David J.