Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
>> Did you make the dump using 8.3's pg_dump?
> Yes, with 8.3.1's pg_dump (data only dump)
That would be your problem. *Don't* use a data-only dump, it
lobotomizes all intelligence in the system and leaves it up to you
to deal with foreign-key ordering issues. There are lots of
performance arguments against that as well. See the advice at
http://www.postgresql.org/docs/8.3/static/populate.html
regards, tom lane