Dan Armbrust <daniel.armbrust.list@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
