Francisco Reyes <lists@xxxxxxxxxxxxxxxx> writes: > Tom Lane writes: >> Can we see the context-sizes dump that should've come out right before >> that in the log? > Hope this is what you are looking for. > Included a few lines before the error in case that is of any help. Well, that's the last few lines of what I wanted, but not the part that was interesting :-(. Please show all the lines that are like the "n total in m blocks" format. Or at least look for the one(s) that contain large numbers... > The table has no insert triggers, but does have a Foreign-key constraint. > "message_attachments_message_id_fkey" FOREIGN KEY (message_id) REFERENCES > messages(message_id) Hmm, you may well be blowing out the deferred-foreign-key-check list. But pg_dump normally orders its operations so that the data is loaded before trying to set up FK constraints. Are you perhaps trying to do a data-only restore? regards, tom lane
