Dan Armbrust <daniel.armbrust.list@gmail.com> writes:
> Jim C. Nasby wrote:
> > pg_dump handles table ordering properly.
> >
>
> 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.
-Doug