I would alter the tables and remove the foreign key constraint, restore the
data and add the constraint back. If the data is consistent, adding the
foreign key should work without error.
On Friday, October 20, 2017 8:15:27 PM PDT doganmeh wrote:
> I was dumping each table to a separate file so I could pick and choose when
> restoring. However, seems this was not a great idea, since two of my tables
> happened to reference each other via FOREIGN KEYs, and I am not able to
> restore them. Is there a way to do this without manually merging the dump
> files? Thanks for guidance in advance.
>
>
>
> --
> Sent from:
> http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html