On Mon, Nov 23, 2015 at 9:27 PM, pinker <pinker@onet.eu> wrote:
> Some tables are inherited. Maybe it's the issue with right order by inheritance? Maybe I can somehow force another
order?
pg_dump is usually able to take care of that automatically and dumps
the data in an order that makes sense by looking at the tree
dependency of relations. One way that would allow you to bypass this
error in any case is to use pg_dump --disable-triggers so as those
integrity checks are disabled when loading the data. This will add in
the dump the necessary commands to do so, thought reloading the dump
will need superuser rights.
--
Michael