Douglas McNaught <doug@mcnaught.org> writes:
> Dan Armbrust <daniel.armbrust.list@gmail.com> writes:
>> Maybe I missed something then, because it didn't last time I tried to
>> move some data. I had to drop my foreign keys before I could reload
>> it.
> What version was this? Older versions definitely had some problems
> with table ordering. In 8.0.X, the tables in the dump all get loaded
> before the FK constraints are created, and I have never seen a
> problem.
Even in current versions, you have to do a full (schema+data) dump for
it to work "right". Data-only dumps are prone to FK problems. This
is insoluble in the general case, though you can work around it to some
extent with the --disable-triggers option.
regards, tom lane
