Devart Forums

Hi all,
I did a backup with pgdump as dmData option and while restoring the database a Foreign key violation occurs, despite the creation order was respected when I first created the db manually. So, is there an option to respect the creation order?
Another thing I figured out, why when dumping the whole database all the sequences become owned by "postres" while thery were originnaly owned by "public", is there an option for that, thanks for your reply.

Hi,
It seems that this issue comes from the fact that the tables are sorted from A to Z in the dump file, did I miss something to keep the original order or I have to do it by myselg programmatically?

Currently TPgDump does not have a feature for sorting tables by dependencies. You can dump tables one by one and add to a commom script in the correct order.