Kasia Tuszynska <ktuszyn...@esri.com> writes: > The problem arises, if data in lets say the adam schema is dependent on > tables in the public schema, since the data in the public schema does not > exist yet, being created later.
That's not supposed to happen. Are you possibly running an early 8.3 release? pg_dump 8.3.0-5 had a problem with user-defined operator classes that could cause misordering of the output. If it's not that, we'll need a lot more information. BTW, the -i switch is dangerous. Don't use it as a routine measure. 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