Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Restoring tables with circular references dumped to separate files - Mailing list pgsql-general

From Uwe
Subject Re: [GENERAL] Restoring tables with circular references dumped to separate files
Date
Msg-id 3430419.aDL8jPP3m8@tiburon
Whole thread Raw
In response to [GENERAL] Restoring tables with circular references dumped to separate files  (doganmeh <mehmet@edgle.com>)
Responses [GENERAL] Re: Restoring tables with circular references dumped to separatefiles  (doganmeh <mehmet@edgle.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: doganmeh
Date:
Subject: [GENERAL] Restoring tables with circular references dumped to separate files
Next
From: Arthur Zakirov
Date:
Subject: Re: [GENERAL] tgrm index for word_similarity