Achilleas Mantzios <[EMAIL PROTECTED]> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
