"Thilo Hille" <thilo@resourcery.de> writes:
> I am using postgresl 7.2.3. Yesterday i have dumped a database using pg_dump
> everthing was fine, but the dump was in the wrong order. There were indexes
> and views createded before the corresponding table was created.
There are some bugs along that line, particularly in older releases.
If you're using one of the archive output formats then pg_restore can
be used to alter the restore order into something that will work.
regards, tom lane